Oracle Solution for Error ora-37127

Solution for Oracle Error ORA-37127

ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object

must be last in the dimension list.

What triggered the Error:

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

What should we do to fix it:

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