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.
