Home » SQL & PL/SQL » SQL & PL/SQL » Dependencies of procedures within a stored package (merged)
Dependencies of procedures within a stored package (merged) [message #390172] Thu, 05 March 2009 05:42 Go to next message
l0b0
Messages: 13
Registered: November 2006
Junior Member
I've seen lots of Q&A about dependencies of stored procedures, tables, etc., but none which explain how to get the dependencies of procedures within a stored package. I can find some information about the procedures by using
select *
  from all_procedures
 where object_name = '&package_name'
 order by subprogram_id
;

, but I can't find a way to get the dependencies of the procedures themselves. I can't find references to subprogram_ids in %_dependencies or sys.dependency$, and from what I've read of utldtree.sql, it doesn't seem to do the job.
Re: Dependencies of procedures within a stored package [message #390180 is a reply to message #390172] Thu, 05 March 2009 06:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Utldtree should work. You can try something like this.
http://www.orafaq.com/forum/m/174241/0/?srch=utldtree#msg_174241
Re: Dependencies of procedures within a stored package [message #390190 is a reply to message #390172] Thu, 05 March 2009 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no tracked dependencies between objects inside packages.
You have to analyze the source to know this.

Regards
Michel
Re: Dependencies of procedures within a stored package [message #390195 is a reply to message #390190] Thu, 05 March 2009 06:54 Go to previous message
l0b0
Messages: 13
Registered: November 2006
Junior Member
Thank you both. I had a look at utldtree.sql, and indeed it looks in all_objects, which doesn't record procedures inside packages.
Previous Topic: Effect of group by?
Next Topic: In list as argument to procedure (merged)
Goto Forum:
  


Current Time: Tue Dec 06 12:11:32 CST 2016

Total time taken to generate the page: 0.08298 seconds