-
How to insert (append) VARCHAR2 in LOB columns
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
Rajeev Suri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|