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