Oracle Solution for Error ora-36395

ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object

, you must specify an AGGMAP.

What triggered the Error:

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

What should we do to fix it:

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