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.