DML operations fail with error ORA-29877, DRG-50857, DRG-10602, "DRG-50857: oracle error in drekqkd (n_stmt)", PLS-103

(Doc ID 1311210.1)

Last updated on NOVEMBER 12, 2015

Applies to:

Oracle Text - Version to [Release 10.2]
Oracle Text - Version to [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Jan-2013***


We have long Text index names with up to 30 characters and schemas with up to 28 characters and some updates failed with following errors:

ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column VAL5 for primary key AAAMoUAAEAAAACUAAA
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1, column 257:
PLS-00103: Encountered the symbol "RD_CMS_FINAL_SCHOTT_INTRANET" when expecting one of the following:
:= . ( @ % ;
ORA-06512: at "CTXSYS.DRUE", line 160

This error occurs after database upgrade from to


Database has been upgraded from to


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