Quick Search:
 
 Oracle Database Error: ORA-01436      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-01436

Error Description:
CONNECT BY loop in user data

Error Cause:
The condition specified in a CONNECT BY clause caused an infinite 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. A loop occurs if one row is both the parent (or grandparent or direct ancestor) and a child (or a grandchild or a direct descendent) of another row.

Action:
Check the CONNECT BY clause and remove the circular reference. Also look in the UDUMP destination for the trace file to find the problematic IDs which are causing the infinite loop in the hierarchy.


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org