Updating clob dating raleigh frame numbers

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.

Last modified 03-Dec-2019 06:52