Database Error Messages

ORA-32491

cycle mark value and non-cycle mark value for CYCLE clause must be either all character values or boolean values

Cause

A CYCLE clause was specified for a recursive WITH query but the cycle mark value and the non-cycle value or DEFAULT value were not all character values or boolean values.


Action

Change either the cycle mark or the non-cycle mark values so that they are the same data type.