SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29877,ORA-20000,DRG-50857,DRG-10602,ORA-00942,ORA-06512

694333Dec 18 2010 — edited Dec 18 2010

my oracle db version is;

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 17 18:07:33 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:

Oracle Database 10g Release 10.2.0.1.0 - Production

and using Form 6i - Forms [32 Bit] Version 6.0.8.25.2 (Production) on Windows XP SP3

on one of my Form while updating a record i am getting all these error together ;

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 REF_NO for primary key AAAMy0AAEAAAAkfAAA
DRG-50857: oracle error in drekqkd(execute k_stmt)
ORA-00942: table or view does not exist

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 678

Please this is the first time i am facing such an error...

Kindly suggest what should be corrected...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2011

Added on Dec 18 2010

1 comment

1,583 views