DRG-10849: Catsearch Does Not Support Functional Invocation
Last updated on MAY 16, 2018
Applies to:Oracle Text - Version 18.104.22.168 and later
Information in this document applies to any platform.
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
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;
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 hundreds of Community platforms