I am working on Oracle Text search and Context indexes.
At one point we have to merge VARCHAR2 columns with LOB columns to build a composite index.

Oracle's document -
http://otn.oracle.com/products/text/...s/imt_815.html

...suggests to use a user-defined function "append_varchar_to_lob" to use that will Append a Varchar column at the end of the LOB but it does not show how to do it.

You can't simply concatenate LOB and VARCHAR2 because of the datatype inconsistency.

The TO_LOB function works only on the LONG columns and that too with many restrictions.

I will really appreciate any help on this.

Thanks,
- Rajeev