Skip to Main Content

SQL Developer

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!

Find dependency on Packaged Function

277530Oct 28 2008 — edited Nov 3 2008
Hi All

I want to find dependencies on packaged function. i.e. the objects that depend on packaged procedure.
let say we have a package P1 and it has 3 Functions F1,F2,F3. I want to find what all other objects (package or procedure or function) depend on P1.F1.

I know how to find dependency on Package as a whole but dont know how to find dependency on packaged function only.

I also know as a work around i can search in all_source table and find in the reference to P1.F1 and get that.

But is their any other way anyone else might have used to find package function dependency?

Thanks
This post has been answered by -K- on Oct 29 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2008
Added on Oct 28 2008
4 comments
1,005 views