Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to find dependency procedure names within a package

prakashSep 8 2011 — edited Sep 8 2011
Hi all,

I have 156 procedures inside a package , i want to find out dependency procedure names .

For example :
Lets say
Package p1 contains sp1,sp2,sp3 procedures and sp1 is calling sp2,sp3 procedures .
In this case for sp2,sp3 dependency procedure is going to be sp1 .

Thanks in advance ...






Thanks,
P Prakash
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2011
Added on Sep 8 2011
6 comments
3,216 views