How to fix the Oracle error DRG-10859: Only one predefined scoring component can be used in DEFINESCORE?

In this post, you’ll learn more about the Oracle ErrorDRG-10859: Only one predefined scoring component can be used in DEFINESCORE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10859: Only one predefined scoring component can be used in DEFINESCORE

Reason for the Error DRG-10859: Only one predefined scoring component can be used in DEFINESCORE

Cause: More than one predefined scoring component (i.e. RELEVANCE, OCCURRENCE, etc.) is used in the scoring expression of the DEFINESCORE operator

How to fix the Error DRG-10859: Only one predefined scoring component can be used in DEFINESCORE ?

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

Action: Rewrite query using only one predefined component