RE: Little OT: CLOB, Oracle Text, and ADO

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
> ian_at_slac.stanford.edu
>
> -----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_at_novali To: Multiple recipients of list
>ORACLE-L <ORACLE-L_at_fatcity.com>
> stech.com> cc:
>
> Sent by: Subject: Little OT: CLOB, Oracle
>Text, and ADO
> root_at_fatcity.com
>
>
>
>
>
> 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
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com
>
> 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: ListGuru_at_fatcity.com (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: ian_at_SLAC.Stanford.EDU
>
> 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: ListGuru_at_fatcity.com (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: wiwaniec_at_novalistech.com

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: ListGuru_at_fatcity.com (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).