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

In this post, you’ll learn more about the Oracle ErrorORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

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

You can fix this error in Oracle by following the below steps

Specify a numerical or boolean weight instead