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 10.2.0.5 to 10.2.0.5 [Release 10.2]
Oracle Text - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Jan-2013***

Symptoms

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
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 679


This error occurs after database upgrade from 10.2.0.4 to 10.2.0.5.

Changes

Database has been upgraded from 10.2.0.4 to 10.2.0.5.

Cause

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