Home » SQL & PL/SQL » Client Tools » Toad Road Map
Toad Road Map [message #311346] Fri, 04 April 2008 03:03 Go to next message
mrk_anand
Messages: 7
Registered: December 2007
Junior Member
Experts,
I am trying to find all the dependencies of a function. The function may call many packages,procedures,functions and may use synonyms,views,etc.. If i query the table USER_Dependencies it gives only the package but not the function inside that package that is being called.

(e.g) package A has the procedure B and function C. Function D is an independent function which uses table-T,View-V,Synonym-S and also it calls the function C inside package A.

If i query USER_DEPENDENCIES for the object 'D' it shows the dependency for the package A along with other Dependencies T,V, and S. I would like the output like 'Package~A.Function~C' I am able achieve the same using "code road map" of toad. I would like to achieve the same using query or PL/SQL program.

Please suggest.
Re: Toad Road Map [message #311356 is a reply to message #311346] Fri, 04 April 2008 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not in Oracle dictionary.

Regards
Michel
Re: Toad Road Map [message #311358 is a reply to message #311346] Fri, 04 April 2008 04:25 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The makers of TOAD wrote their own parser. Oracle's data dictionary does not support sub-package-level dependencies.

Ross Leishman
Re: Toad Road Map [message #312161 is a reply to message #311358] Tue, 08 April 2008 02:22 Go to previous messageGo to next message
mrk_anand
Messages: 7
Registered: December 2007
Junior Member
Any suggestions of how to start approaching this one.
Re: Toad Road Map [message #312176 is a reply to message #312161] Tue, 08 April 2008 02:40 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Get the package code from all_source and analyze it.

Regards
Michel
Previous Topic: Pasword reset
Next Topic: DBMS_SQL And Commit Problem
Goto Forum:
  


Current Time: Sun Dec 11 04:37:36 CST 2016

Total time taken to generate the page: 0.21983 seconds