How to fix the Oracle error DRG-10865: invalid datatype in user scoring expression?

In this post, you’ll learn more about the Oracle ErrorDRG-10865: invalid datatype in user scoring expression with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10865: invalid datatype in user scoring expression

Reason for the Error DRG-10865: invalid datatype in user scoring expression

Cause: The scoring expression specified in DEFINESCORE or NORMALIZATION_EXPR in the query template either contains components with unsupported datatypes or does not return numerical values.

How to fix the Error DRG-10865: invalid datatype in user scoring expression ?

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

Action: Rewrite the scoring expression.