重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-37133: (XSCCOMP08) You cannot write into an aggregated VARIABLE [打印本页]

作者: michaeljet 时间: 2016-9-7 09:44
标题: ORA-37133: (XSCCOMP08) You cannot write into an aggregated VARIABLE

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.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)