Database Error Messages

OCI-32482

sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause

Cause

A SEARCH clause and a CYCLE clause was specified for a recursive WITH query, but the sequence column of the SEARCH clause matched the cycle mark column of the CYCLE clause.


Action

Change either the sequence column or the cycle mark column so that they no longer match.