Database Error Messages

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

OCI-30008

CONNECT BY clause must reference a PRIOR

Cause

A CONNECT BY clause did not include a predicate referencing a PRIOR so there was no condition connecting a parent row to its child row.


Action

Add a reference to a PRIOR in the CONNECT BY clause.