dependency checker

How can I check which object is relaying on a function or procedure ?

Cheers,
Andrew
andrewyuAsked:
Who is Participating?
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
use something like the below :

SELECT *
FROM dba_dependencies
WHERE owner ='SCOTT'
AND name ='MY_FUNCTION';

Thanks
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
if you do not have access to dba_dependencies,  then try all_dependencies.

if not, then you have to use

SELECT *
FROM USER_dependencies
WHERE name ='MY_FUNCTION'

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.