Oracle Error ORA-36764: (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.

Oracle Error Message

ORA-36764: (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.

Reason for the Error

An attempt was made to create a non-INTEGER AGGCOUNT.

Solution

Select an INTEGER AGGCOUNT variable.