Oracle Error ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

Oracle Error Message

ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

Reason for the Error

The user supplied an undimensioned (scalar) variable to the ALLOCATE command.

Solution

Use a dimensioned variable.