Category Archives: DRG Database Error Messages

DRG-10849: catsearch does not support functional invocation

oracle

DRG-10849: catsearch does not support functional invocation
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
Action: add optimizer hints so that all catsearch operators are performed through index scans

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10848: invalid structured clause

oracle

DRG-10848: invalid structured clause
Cause: you have specified an invalid structured clause
Action: none

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10847: catsearch requires prefix index for this type of queries

oracle

DRG-10847: catsearch requires prefix index for this type of queries
Cause: For efficient execution of this Vgram query we require presence of a prefix index
Action: create a prefix index

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10846: order by columns must be all ascending or all descending

oracle

DRG-10846: order by columns must be all ascending or all descending
Cause: You specified an order by clause which has some columns ascending and some descending. This is not currently supported by catsearch
Action: none

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10845: column string is not indexed

oracle

DRG-10845: column string is not indexed
Cause: You specified a column in a condition or order by which is not part of the ctxcat index
Action: none

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10844: index cannot execute this structured predicate efficiently

oracle

DRG-10844: index cannot execute this structured predicate efficiently
Cause: You specified a combination of condition and order by columns in a catsearch query which cannot be executed by the index's index set efficiently
Action: none

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10843: invalid WEIGHT argument supplied to FUZZY

oracle

DRG-10843: invalid WEIGHT argument supplied to FUZZY
Cause: An invalid value was supplied for WEIGHT argument to FUZZY
Action: Set WEIGHT to WEIGHT or NOWEIGHT

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10842: invalid NUMRESULTS argument supplied to FUZZY

oracle

DRG-10842: invalid NUMRESULTS argument supplied to FUZZY
Cause: An invalid value was supplied for NUMRESULTS argument to FUZZY
Action: Provide a valid NUMRESULTS. Valid values are integers from 0 to 5000

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10841: invalid SCORE argument supplied to FUZZY

oracle

DRG-10841: invalid SCORE argument supplied to FUZZY
Cause: An invalid value was supplied for SCORE argument to FUZZY
Action: Provide a valid SCORE. Valid values are integers from 0 to 80

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint

oracle

DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint
Cause: User attempts to issue a query with CONTAINS predicate including 0 while giving FIRST_ROWS hint
Action: remove FIRST_ROWS hint

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/