Dependency of procedure in Oracle:

Question

Hi all I am new to DATABASE. I am trying to figure out the way to find the procedure dependent on another procedure.

Below query is giving me the dependecy of PROC1. ie Procedure called by PROC1

select REFERENCED_NAME from user_dependencies where name = 'PROC1' ;

Below things I want to know:

1) Is this query even work same for Function. ?

2) Is this query is recursive ie PROC1 calls-> PROC2 calls ->PROC3 calls -> PROC4 Ie: when I call the query for PROC1 whill it give all dependency or only one level dependency(ie PROC2).

3) If the procedure is inside the package to find the dependency what should be the query ?

Answer 1

1. yes

2. no, it only shows an immediately level of dependency

3. user_dependencies only shows a dependency at the package level, not for individual procedures and functions within the package.

PL/Scope (introduced in 11g) allows you to find usages at the procedure/function level within a package, but it only works if it's enabled when the code is compiled.