OCI-62507
illegal use of MATCH_NUMBER or CLASSIFIER in MATCH_RECOGNIZE clause
Cause
An attempt was made to use MATCH_NUMBER or CLASSIFIER in the MATCH_RECOGNIZE clause. CLASSIFIER and MATCH_NUMBER can only be used in the MEASURES clause. CLASSIFIER and MATCH_NUMBER cannot be used inside aggregates/FIRST/LAST/PREV/NEXT.
Action
Modify the query and retry the operation.
OCI-62507
illegal use of MATCH_NUMBER or CLASSIFIER in MATCH_RECOGNIZE clause
Cause
An attempt was made to use MATCH_NUMBER or CLASSIFIER in the MATCH_RECOGNIZE clause. CLASSIFIER and MATCH_NUMBER can only be used in the MEASURES clause. CLASSIFIER can only be used if the query is ALL ROWS PER MATCH. CLASSIFIER and MATCH_NUMBER cannot be used inside aggregates/FIRST/LAST/PREV/NEXT.
Action
Modify the query and retry the operation.
OCI-62507
illegal use of MATCH_NUMBER or CLASSIFIER in MATCH_RECOGNIZE clause
Cause
An attempt was made to use MATCH_NUMBER or CLASSIFIER in the MATCH_RECOGNIZE clause. CLASSIFIER and MATCH_NUMBER can only be used in the MEASURES clause. CLASSIFIER can only be used if the query is ALL ROWS PER MATCH. CLASSIFIER and MATCH_NUMBER cannot be used inside aggregates/FIRST/LAST/PREV/NEXT.
Action
Modify the query and retry the operation.