Home » SQL & PL/SQL » SQL & PL/SQL » Package Dependencies (Oracle
Package Dependencies [message #420339] Fri, 28 August 2009 07:47 Go to next message
Messages: 10
Registered: July 2006
Junior Member
I want to get the dependency Chain for particular package.

I am using following query to achieve this.

FROM all_dependencies
START WITH referenced_name = 'SOME_PACKAGE_NAME'
CONNECT BY PRIOR NAME = referenced_name

I am getting ORA-01436 Connect By Loop in User Data.Also I am getting some duplicate records.

I am trying hard to get around this issue.Any help in this regard much appreciated.
Re: Package Dependencies [message #420342 is a reply to message #420339] Fri, 28 August 2009 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing can be done, there is a loop in the dependencies you have to either upgrade or create your PL/SQL program.

Re: Package Dependencies [message #420383 is a reply to message #420342] Fri, 28 August 2009 15:52 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
in 10g, try NOCYCLE.

select level, name, referenced_name, CONNECT_BY_ISCYCLE
from all_dependencies 
start with referenced_name = 'STANDARD'
connect by NOCYCLE prior name = referenced_name 
Previous Topic: utl_smtp Authentication POP3 before SMTP - ORA-29279
Next Topic: Global Hints for Scalar subquery
Goto Forum:

Current Time: Sun Oct 23 09:35:27 CDT 2016

Total time taken to generate the page: 0.10748 seconds