catsearch does not support functional invocation

Solution ID:DRG-10849

Type: Oracle

Cause

the query plan for your query is invoking a catsearch operator functionally rather than as an index rowsource. The catsearch operator does not support functional invocation

Actions

add optimizer hints so that all catsearch operators are performed through index scans

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/drgus.htm


https://community.oracle.com/message/10507599


https://community.oracle.com/message/148087


https://community.oracle.com/message/10491006


https://community.oracle.com/message/2771939


https://community.oracle.com/message/1229219


https://community.oracle.com/message/2619135


https://community.oracle.com/message/900004


https://community.oracle.com/message/2789727


https://community.oracle.com/message/10649814


https://community.oracle.com/message/1209659


https://community.oracle.com/message/1085902


https://community.oracle.com/message/10494364


https://community.oracle.com/message/9313175


https://community.oracle.com/message/2847094


https://community.oracle.com/message/2435851


Browse all solutions to database errors from Oracle, MS SQL, or MySQL