Oracle Error: ORA-01436
CONNECT BY loop in user data
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