Thanks for the reply I have tried ctx_ddl.sync_index() but it can be used to synchronize ctxsys.context indexes only. In my case it is ctxsys.ctxcat index. Since it gets updated properly when I use few different ways to insert records I believe it is something specific to the way ADODB.Recordset modifies database.
The index gets updated properly when I run, in any way, an INSERT statement. I guess the ADODB.Recordset works on a different level. It may be something similar to differences in loading data with SQL Loader using conventional load and direct load - issuing INSERT statements vs. writing directly to the table. It is just a guess... Witold On 21 Dec 2001 at 10:00, MacGregor, Ian A. wrote: > Ctxserv has been deprecated. Check the directory $ORACLE_HOME/ctx/sample/script >for the approved ways of keeping the indexes in synch. > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Friday, December 21, 2001 9:41 AM > To: Multiple recipients of list ORACLE-L > > > > My experience with intermedia or context server, or whatever > they call it this week, is in dealing with iFS, so I know just > enough to be dangerous. :) > > It sounds like you need to have the context server running > to periodically update the indexes. > > On unix it's 'ctxsrv'. I suggest you read the docs on this > and do a search on metalink, there is some helpful > information there. > > HTH > > Jared > > > > > > > "Witold Iwaniec" > > <wiwaniec@novali To: Multiple recipients of list >ORACLE-L <[EMAIL PROTECTED]> > stech.com> cc: > > Sent by: Subject: Little OT: CLOB, Oracle >Text, and ADO > [EMAIL PROTECTED] > > > > > > 12/21/01 07:15 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > Hello > > It may be little OT but I am sure there are developers here. Also I > hope some DBAs may know the answer... > > I am experimenting with Oracle Text - need to use the field from a > VB application. > > I have a table with a CLOB column and a ctxcat index built on that > column. If I insert records using SQL Plus, TOAD, or similar tool, > the index is automatically updated so my query: > > select note_oid from lrmi_note > where catsearch(note_data, 'SomeValue', null) > 0; > > returns records matching the condition. > > In the application - if I use ADODB.Connection with parameters and > execute my insert, the data is written, index automatically updated, > and my query returns matching records. > > But if I use ADODB.Recordset to write the record, the data is written > but the index doesn't get updated. If I open SQL Plus and run: > > select * from lrmi_note where note_oid = my_new_oid; > > it shows me the record with the CLOB column filled. But if I query > the CLOB column using catsearch(), it doesn't return the record. If I > rebuild the index, the query with catsearch() will return the records. > But one of the reasons to use ctxcat indes is that it is updated with > each transaction... > > While it may be specific to ADO I wonder if some Oracle gurus > know, or can direct to some info, why Oracle doesn't update the > ctxcat index even though the record is written and apears correctly. > > Witold================================== > Witold Iwaniec > Sr Software Developer > NovaLIS Technologies > [EMAIL PROTECTED] > http://www.novalistech.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Witold Iwaniec > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MacGregor, Ian A. > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
