Database Error Messages

OCI-62506

illegal nesting of operators in MATCH_RECOGNIZE clause

Cause

An attempt was made to nest aggregates/FIRST/LAST/PREV/NEXT. Aggregates/FIRST/LAST/PREV/NEXT cannot be nested. The only exception allowed is PREV/NEXT(FIRST/LAST()).


Action

Modify the query and retry the operation.