DRG-10849: Catsearch Does Not Support Functional Invocation (Doc ID 2398630.1)

Last updated on APRIL 06, 2022

Applies to:

Symptoms

An Oracle Text query whiich uses the CATSEARCH operator is not using the domain (CTXCAT) index and instead running a full table scan and giving the below error.

ORA-20000: Oracle Text error:
DRG-10849: catsearch does not support functional invocation

Example:

SELECT ....
FROM FD, BUS
WHERE (CATSEARCH(FD.BUS_RULE_ID_S, 'AD'||BUS.RULE_ID_I, NULL) > 0)
GROUP BY BUS.RULE_ID_I, FD.FLT_ID_I, FD.FLT_DPTR_DATE_D;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.