ORA-32617: missing MEASURES keyword in MODEL clause
Cause: The MEASURES keyword was not specified where it is expected
Action: Specify the MEASURES keyword or check the SQL statement
https://support.oracle.com/
http://www.oracle.com/
Category Archives: ORA Database Error Messages
ORA-32616: missing DIMENSION BY keyword in MODEL clause
ORA-32616: missing DIMENSION BY keyword in MODEL clause
Cause: The DIMENSION keyword was not pecified where it is expected
Action: Specify the DIMENSION keyword or check the SQL statement
ORA-32615: incorrect use of MODEL IS ANY predicate
ORA-32615: incorrect use of MODEL IS ANY predicate
Cause: IS ANY predicate is used outside dimension expression or with non-dimensional or different dimensional arguments
Action: Check the SQL statement and rewrite if necessary
ORA-32614: illegal MODEL SELECT expression
ORA-32614: illegal MODEL SELECT expression
Cause: An expression other than MODEL aliases, constants, or expressions of the two is specified in the MODEL SELECT clause
Action: Reformulate the query, perhaps nesting inside another SELECT
ORA-32613: not a MODEL cell
ORA-32613: not a MODEL cell
Cause: The operator requires a MODEL cell as operand
Action: Specify MODEL cell as operand, check SQL statement
ORA-32612: invalid use of FOR loop
ORA-32612: invalid use of FOR loop
Cause: The MODEL FOR loop was used where it is not allowed. FOR loops are not allowed in complex dimensional predicates, on the right hand side of rules, or in the until condition
Action: Check the SQL statement and rewrite if necessary
ORA-32611: incorrect use of MODEL CV operator
ORA-32611: incorrect use of MODEL CV operator
Cause: CV function was used outside a dimension expression, in UNTIL condition, or with non-dimensional arguments
Action: Check the SQL statement and rewrite if necessary
ORA-32610: missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause
ORA-32610: missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause
Cause: SINGLE REFERENCE or DIMENSION keyword was not specified where it is expected
Action: Specify the applicable keywords or check the SQL statement
ORA-32609: missing REFERENCE keyword in MODEL clause
ORA-32609: missing REFERENCE keyword in MODEL clause
Cause: The REFERENCE keyword was not specified where it is expected
Action: Specify the REFERENCE keyword or check the SQL statement
ORA-32608: missing INCREMENT or DECREMENT keyword in FOR loop
ORA-32608: missing INCREMENT or DECREMENT keyword in FOR loop
Cause: INCREMENT or DECREMENT keyword was not specifiedi where it is expected
Action: Specify the INCREMENT or DECREMENT keyword or check the SQL statement