Quick Search:
Oracle PL/SQL Code Library
Find Or Post Oracle Jobs
Oracle Discussion & Chat
 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.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 30 users online    © 2009 psoug.org

Forgot your password?