I want to insert a value into a clob column in a table. The value should be concatenated using a clob value from another table, a long value and some characters. Like this:
insert into mytable1 (myclobcol)
select clobcol || longcol || ' }'
I have tried all kinds of conversions and I get all kinds of error messages related to faulty datatypes.