Oracle Error ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.

Oracle Error Message

ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.

Reason for the Error

The user attempted to DEFINE a variable dimensioned by a COMPRESSED COMPOSITE, but gave a slower varying dimension in the dimension list.

Solution

Put the COMPRESSED COMPOSITE last in the dimension list when defining the VARIABLE.