Expand To Show Full Article
Oracle Error ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string. - Developer Publish

Oracle Error ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.

Oracle 4 Views 0 Min Read

Oracle Error Message

ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.

Reason for the Error

The user specified a WEIGHT variable or formula which wasn’t numeric or boolean

Solution

Specify a numerical or boolean weight instead

Tags: