intermedia Text Question

We have a table of documents
(id number,
 doctext clob)

We have a text index (8i) on this on doctext.

The table has historically been populated by users pasting the text of the document into a browser window and then this text just inserted directly into the doctext column using plsql.

Now we want to be able to let some users upload documents to the filesystem and we want to be able to get the text from those docs into the same table so that the text is indexed.

It is necessary (preferable I should say really) to support the 2 methods in parallel. I wonder if anyone can see a way of doing this? I need a solution to this even if it is not optimal/elegant - it will be superseded with a more advanced approach in the medium-term.

I was thinking along the lines of manually invoking $ORACLE_HOME/ctcx/lib/ctxhx to extract the text from the uploaded document and then write the resultant text back into the table.

Is that a stupid idea?

Thanks ......

Jeremy Received on Tue Jan 15 2002 - 11:44:32 CST