ORA-37133: (XSCCOMP08) Cannot write into an aggregated VARIABLE dimensioned by

ORA-37133: (XSCCOMP08) Cannot write into an aggregated
VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the
CLEAR AGGREGATES command to reenable write access.

Question Posted / guest

1 Answers
2209 Views
I also Faced
E-Mail Answers

ORA-37133: (XSCCOMP08) Cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSI..

Answer / guest

Cause: The user attempted to store a value into to a
variabled dimensioned by a compressed composite, and the
variable had previously been precomputed using the AGGREGATE
command. Once the AGGREGATE command is run on a variable
dimensioned by a compressed composite, it becomes read-only
until the computed values are removed with the CLEAR command.

Action: Run the CLEAR AGGREGATES command to remove the
computed values from the variable and then rerun the failed
operation. Note that CLEAR AGGREGATES will remove all the
data computed during the last AGGREGATE command on this
variable.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer