How to fix the Oracle error DRG-10860: All expressions under the same WITHIN must use the same predefined scoring component?

In this post, you’ll learn more about the Oracle ErrorDRG-10860: All expressions under the same WITHIN must use the same predefined scoring component with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10860: All expressions under the same WITHIN must use the same predefined scoring component

Reason for the Error DRG-10860: All expressions under the same WITHIN must use the same predefined scoring component

Cause: The query side of the same within mixes different types of scoring components(i.e. RELEVANCE, OCCURRENCE, etc.)

How to fix the Error DRG-10860: All expressions under the same WITHIN must use the same predefined scoring component ?

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

Action: Rewrite query using only one type of predefined component