Oracle database error code ORA-01436 – CONNECT BY loop in user data

Oracle Database Error Code ORA-1436 Description :
CONNECT BY loop in user data
Error Cause:
The condition specified in a CONNECT BY clause caused a loop in the query, where the next record to be selected is a descendent of itself. When this happens, there can be no end to the query.

How to Solve :
Check the CONNECT BY clause and remove the circular reference.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»