By the way i love the desperado movie with Banderas :-) Take care Samatar Yea, good movie.
Your dynamic SQL is trying to concatenate the CLOB as part of the SQL statement, turning it into a string literal.
If dynamic SQL were required, you'd need to use bind variables.
We are using Oracle Native (JDBC) connections and insert quite a bit into CLOB fields without any issues. I see ojdbc14as well as orai18in my Kettle install path .../data-integration/libext/JDBC along with many other jars.
I also have oracle XE in stalled on my machine whch has it's own copy of ojdbc14
I have tentatively solved this problem by issuing an update statement and simply updating my field in the table (it is a CLOB) with the data necessary after the EXECUTE IMMEDIATE and leaving it null in the initial insert.