Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-01436

CONNECT BY loop in user data

Cause

The condition specified in a CONNECT BY clause caused a loop in the query, where the next record to be selected was a descendent of itself. When this happens, there could be no end to the query.


Action

Check the CONNECT BY clause and remove the circular reference.