I have the most bizarre thing happening!
I have an Oracle (8.1) table containing a CLOB column. When I insert a row using an InsertSQL adapter service, the CLOB field is assigned correctly, along with all the other fields. However, when I try to update a row using an UpdateSQL adapter service, the CLOB field is assigned NULL if the incoming CLOB string exceeds 333 characters! It doesn’t seem to be related to the overall SQL statement size, as I can increase the length of other non-CLOB fields in the update without affecting the length at which the CLOB is nulled. There’s no special character near position 333.
I could understand hitting a thin driver limit at 2000 or 4000 or 64000 characters, but 333???
Using the oracle oracle/product/8.1.7/jdbc/lib/classes12.zip driver.