| Toad Road Map [message #311346] |
Fri, 04 April 2008 03:03  |
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 #311358 is a reply to message #311346] |
Fri, 04 April 2008 04:25  |
rleishman
Messages: 3728
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
