ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.
Cause: The CLEAR command could not determine how the variable was aggregated because the variable is not dimensioned by a compressed composite.
Action: Specify an aggmap by adding a USING phrase to the CLEAR command, or attach a ''$AGGMAP'' property to the variable.
Error Type: ORA