Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00920: invalid relational operator

009Nov 13 2009 — edited Nov 13 2009
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*
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2009
Added on Nov 13 2009
2 comments
1,657 views