Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » SQL & PL/SQL » SQL & PL/SQL » Toad Road Map
Toad Road Map [message #311346] Fri, 04 April 2008 03:03 Go to next message
mrk_anand
Messages: 6
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.
Report message to a moderator
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: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
This is not in Oracle dictionary.

Regards
Michel
Report message to a moderator
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: 2563
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
Report message to a moderator
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: 6
Registered: December 2007
Junior Member
Any suggestions of how to start approaching this one.
Report message to a moderator
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: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Get the package code from all_source and analyze it.

Regards
Michel
Report message to a moderator
Previous Topic:Execution of Clob through dynamic sql
Next Topic:Minute Differences
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 05:23:26 CDT 2008

Total time taken to generate the page: 0.04769 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.