Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: How to get the list of tables used in a Stored Procedures

    Dear Gurus,

    I am looking for something like Sp_depends 'sp1' (MS SQL Server) in Oracle
    plz post.



    Thanks in advance
    Srinivas

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Have a look at User_Dependencies :

    Code:
    SELECT * 
    FROM User_Dependencies D
    WHERE D.Type = 'PROCEDURE'
    AND D.Name = 'sp1';
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by RBARAER
    Have a look at User_Dependencies :

    Code:
    SELECT * 
    FROM User_Dependencies D
    WHERE D.Type = 'PROCEDURE'
    AND D.Name = 'sp1';
    it also may be

    Code:
    SELECT * 
    FROM User_Dependencies D
    WHERE D.Type = 'PROCEDURE'
    AND D.Name = 'SP1';
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Quote Originally Posted by beilstwh
    it also may be
    should be
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  5. #5
    Join Date
    Aug 2008
    Posts
    1
    How to write a procedure that will return a Table object.[Oracle]

    Thanks & Regards,
    Pankaj Bahuguna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •