My Oracle Support Banner

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

Last updated on MAY 16, 2018

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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