ORA-37133: (XSCCOMP08) You cannot write into an aggregated VARIABLE

michaeljet

ORA-37133: (XSCCOMP08) You cannot write intoan aggregated VARIABLE

dimensioned by a COMPRESSED COMPOSITE. Usethe CLEAR

AGGREGATES command to reenable write access.

Cause: The user attempted to store avalue into to a variable dimensioned by a

compressed composite, and the variable had previouslybeen precomputed using

the AGGREGATE command. Once the AGGREGATE command is runon a

variable dimensioned by a compressed composite, itbecomes read-only until the

computed values are removed with the CLEAR command.

Action: Run the CLEAR AGGREGATEScommand to remove the computed

values from the variable and then rerun the failedoperation. Note that CLEAR

AGGREGATES will remove all the data computed during thelast AGGREGATE

command on this variable.