Oracle Text, CLOB, and ADO

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 query using another column:

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.

Thanks

Witold Received on Fri Dec 21 2001 - 19:35:38 CET