Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

dependency checker

Posted on 2007-11-20
4
Medium Priority
?
438 Views
Last Modified: 2013-12-19
How can I check which object is relaying on a function or procedure ?

Cheers,
Andrew
0
Comment
Question by:andrewyu
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 140 total points
ID: 20318397
use something like the below :

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

Thanks
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 20318406
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question