Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 439
  • Last Modified:

dependency checker

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

Cheers,
Andrew
0
andrewyu
Asked:
andrewyu
  • 2
1 Solution
 
Naveen KumarProduction 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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now