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!

CLOBs and Oracle Text

294918Dec 4 2003 — edited Dec 6 2003

I am prototyping in Java a capability of storing XML data in CLOBs and then using Oracle Text to utilize the CONTAINS function. I am having problem returning data.

Before I moved to using a CLOB, I was just using a varchar2 and inserted some records with XML text within the columns. When I was ready to implement CLOBs and the Oracle Text capability, I just updated the new CLOB column with the to_clob() function and I was able to use the Oracle Text fine. Now that the program is creating new records using the appropriate CLOB steps, Oracle Text cannot find the new records, only the old. I do not receive and error and the context index was created without error.

I am currently prototyping with Oracle 9i DB - 9.2.0.1.0 - Personal Edition, with Java J2SE 1.4.1.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2004

Added on Dec 4 2003

#database-key-features, #text

2 comments

288 views