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 get lowest level of dependencies in oracle procedure

552165Feb 8 2007 — edited Feb 8 2007
hi

i have some quieries regarding dependency between procedures
i have proc 1 calling proc 2 and proc 3
and proc 2 is calling proc 21 and proc 22 and proc 21 is calling proc 211
proc 1
porc 2
proc 21
proc 211
proc 22
proc 3

is there any view of oracle to get lowest level of dependecy.
becuase from user dependencies we get only 1st level dependency
i thing i dont no level of of dependencies.
so hw u can i get exact list that--proc on which proc 1 dependency is there
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2007
Added on Feb 8 2007
3 comments
583 views