Database Error Messages

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

ORA-62508

illegal use of aggregates or navigation operators in MATCH_RECOGNIZE clause

Cause

An attempt was made to define aggregates/FIRST/LAST/PREV/NEXT over multiple variables. Aggregates/FIRST/LAST/PREV/NEXT cannot be defined over multiple variables.


Action

Modify the query and retry the operation.