Find dependency on Packaged Function
277530Oct 28 2008 — edited Nov 3 2008Hi 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