Dear Gurus,
The below given SQL has thrown the above mentioned error
SELECT CONNECT_BY_ISCYCLE CYCLE_,NAME,REFERENCED_NAME
FROM ALL_DEPENDENCIES
WHERE OWNER = 'USER_1A'
AND REFERENCED_OWNER = 'USER_1A'
AND REFERENCED_TYPE IN ('PROCEDURE', 'FUNCTION', 'PACKAGE')
AND TYPE IN ('PROCEDURE', 'FUNCTION', 'PACKAGE')
START WITH NAME = 'IFRS_LOAN_IRR_PROC'
CONNECT BY NOCYCLE PRIOR REFERENCED_NAME = NAME;
SELECT *
FROM V$VERSION
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
5 rows selected
What is wrong in the code is what I'm unable to understand
Thanks for reading this post
*009*