Skip to Main Content

Database Software

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!

Oracle text error

694333Dec 18 2010 — edited Dec 20 2010
hi all,, (i am sorry for posting my problem question again in this TEXT forum.)

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

i have 2 queries that i got as a solution from the forum...

No. 1)  written on  in WHEN-TIMER-EXPIRED
 
CURSOR C_DO_DET IS
SELECT PROD_CODE, UOM,
.
.
.
AND 	DNO IN (select column_value
               from   table(cast(multiset(select substr( str
                                                            , instr (str, ',', 1, level  ) + 1
                                                            , instr (str, ',', 1, level+1) - instr (str, ',', 1, level) -1 
                                                            )
                                            from ( select ','||:ref_NO||',' str 
                                                   from   dual
                                                 )
                                            connect by level <= length(str)-length(replace(str,',',''))-1
                                           )
                               as sys.odcinumberlist 
                             ))
                  )
GROUP BY PROD_CODE, UOM;
 
No. 2) written on WHEN-VALIDATE-ITEM on a field
 
	CURSOR  UNIK_QUOT IS 	SELECT DISTINCT REF_NO 
							FROM   DORDER_HEADER;
                      	AND    DNO IN (select column_value
                 				from   table(cast(multiset(select substr( str
                                                            , instr (str, ',', 1, level  ) + 1
                                                            , instr (str, ',', 1, level+1) - instr (str, ',', 1, level) -1 
                                                            )
                                            from ( select ','||:REF_NO||',' str 
                                                   from   dual
                                                 )
                                            connect by level <= length(str)-length(replace(str,',',''))-1
                                           )
                               as sys.odcinumberlist 
                             ))
                  );
are the above queries reason for the errors that i am receiving...

The record initially getting saved, the errors comes only when i update a record..

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

Kindly suggest what should be corrected...

TY
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2011
Added on Dec 18 2010
2 comments
1,230 views