NukeEmUp
asked on
Appending VARCHAR to CLOB
I'm writing a trigger which will, when a row is INSERTed, populate a field with a concatenation of four of the inserted fields. Some fields are CLOBs and some are VARCHARs. Appending CLOBs to each other is easy - DBMS_LOB.APPEND(), as is appending VARCHARs to each other - using ||. But how do I append a VARCHAR to a CLOB?
DBMS_LOB.APPEND() throws all its toys on the floor and I can't find a suitable conversion function.
DBMS_LOB.APPEND() throws all its toys on the floor and I can't find a suitable conversion function.
ASKER
Points increased to 200 cos this is getting urgent ;-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You're right - it was too late. To get the code finished on time I didn't bother with a trigger, just did the concatenation in perl before bunging the data into Oracle. But now I know how it _should_ be done so I'll give you the points anyway ;-)
ASKER