matches does not support functional invocation

Solution ID:DRG-10868

Type: Oracle

Cause

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

Actions

add optimizer hints so that all matches 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/10019083


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