ORA-32627: illegal pattern in MODEL FOR LIKE loop
Cause: The FOR LIKE pattern had zero or more than one wild characters
Action: Simplify the pattern to have a single wildcard character
https://support.oracle.com/
http://www.oracle.com/
Category Archives: ORA Database Error Messages
ORA-32626: illegal bounds or increment in MODEL FOR loop
ORA-32626: illegal bounds or increment in MODEL FOR loop
Cause: FOR loop allows only numeric and datetime without timezone type for bounds. Only constants of interval and numeric types are allowed as increment/decrement expressions
Action: Check the SQL statement and rewrite if necessary
ORA-32625: illegal dimension in cell reference predicate
ORA-32625: illegal dimension in cell reference predicate
Cause: A non-positional dimension was referenced in the predicate
Action: Check the SQL statement and rewrite if necessary
ORA-32624: illegal reordering of MODEL dimensions
ORA-32624: illegal reordering of MODEL dimensions
Cause: The expressions to qualify dimensions were specified in an incorrect order within a cell reference
Action: Reorder dimension expressions in the cell reference
ORA-32623: incorrect use of MODEL PRESENT* functions
ORA-32623: incorrect use of MODEL PRESENT* functions
Cause: A PRESENT* function (IS PRESENT, PRESENTV, PRESENTNNV) was used in a measure expression
Action: Check the SQL statement and rewrite if necessary
ORA-32622: illegal multi-cell reference
ORA-32622: illegal multi-cell reference
Cause: Multi-cell reference was specified on a measure expression without an aggregate function
Action: Use an aggregate function on the measure expression or qualify the cell reference
ORA-32621: illegal aggregation in UNTIL iteration condition
ORA-32621: illegal aggregation in UNTIL iteration condition
Cause: An aggregate function was used in UNTIL condition
Action: Check the SQL statement and rewrite if necessary
ORA-32620: illegal subquery within MODEL rules
ORA-32620: illegal subquery within MODEL rules
Cause: A subquery was used illegally within the MODEL rule
Action: Check the SQL statement and rewrite if necessary
ORA-32619: incorrect use of MODEL ITERATION_NUMBER
ORA-32619: incorrect use of MODEL ITERATION_NUMBER
Cause: ITERATION_NUMBER was used outside of an iterated MODEL
Action: Check the SQL statement and rewrite if necessary
ORA-32618: incorrect use of MODEL PREVIOUS function
ORA-32618: incorrect use of MODEL PREVIOUS function
Cause: The MODEL PREVIOUS function was used outside of MODEL "ITERATE UNTIL" clause, or was nested
Action: Check the SQL statement and rewrite if necessary