Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-33557: (MAINTCHK01) You cannot [string] values of dimension workspace object during a loop over it.
Oracle® Database Error ORA-33557115/21

ORA-33557: (MAINTCHK01) You cannot [string] values of dimension workspace object during a loop over it.

Cause: User tried to insert or delete a value of the specified dimension while some loop over that dimension was active. The loop could be an explicit FOR or ACROSS loop, or a natural expression evaluation or OLAP_TABLE loop. Also, it could be a loop over the dimension itself or over a derived dimension (like a composite or partition template) or dimension alias that includes it. The insert or delete could be explicitly caused by the MAINTAIN command. It is also possible that the user attempted to assign a value to a variable or partition dimensioned by a composite during a loop over that composite using a qualified data reference (QDR), and that the exception was generated by the engine''s attempt to insert a new position in the composite to hold the new value.

Action: Move the dimension maintenance or QDR-based variable assignment outside the dimension loop.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle