CLOBs and Oracle Text
294918Dec 4 2003 — edited Dec 6 2003I 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.