ORA-29902 Error DRG-100 arguments : [50935],[drpn.c] from CONTEXT Grammar in CATSEARCH Queries Template

(Doc ID 972992.1)

Last updated on AUGUST 07, 2011

Applies to:

Oracle Text - Version: to - Release: 10.2 to 11.2
Information in this document applies to any platform.
Checked for relevance on 08-Aug-2011


Running a catsearch query which use "-" in a context query grammar is leading to an internal error:

SQL> select *
from srch_tbl
where catsearch(prod_name,'
<query><textquery grammar="context">('||'(smith-%)'||')</textquery></query>','')>0;

select *
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-00100: internal error, arguments : [50935],[drpn.c],[5021],[],[]


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