Link to home
Start Free TrialLog in
Avatar of Jay Roy
Jay RoyFlag for United States of America

asked on

finding 'function' references

hi guys
i am using Oracle SQL developer and SQL plus. In Oracle SQL developer  i see
functions and under functions i see 'store_utility'.

I want to search where all this 'store_utility' function is being called/used.
How can i know that?

thanks
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jay Roy

ASKER

>>>select name from dba_dependencies where referenced_name = 'STORE_UTILITY';


it says
 ORA-00942:table of view does not exist
Avatar of Jay Roy

ASKER

>>Roy, this is an oddity as the only close reference I find relates to the web application server or else a non-Oracle database.

dont understand..
I want to check where all this function STORE_UTILITY   is used...in other words i want to find out which procedures are calling STORE_UTILITY.

thx
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My bad, I thought you were seeing a default object rather than a custom one.
Avatar of Jay Roy

ASKER

nav_kum_v,
perfect.

thanks guys.
Good and thanks.