Oracle Error ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.

Oracle Error Message

ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.

Reason for the Error

The CLEAR command could not determine how the variable was aggregated because the variable is not dimensioned by a compressed composite.

Solution

Specify an aggmap by adding a USING phrase to the CLEAR command, or attach a ‘$AGGMAP’ property to the variable.