Oracle Solution for Error ora-36160

Solution for Oracle Error ORA-36160

ORA-36160: (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object

.

What triggered the Error:

The user tried to run the AGGREGATE or AGGCOUNT command or function on a scalar variable.

What should we do to fix it:

Specify a dimensioned variable instead