Unable to insert String data into Oracle Clob field using JDBC adapter service

, ,
1

Hi All,

We are facing an issue when inserting/updating JSON string into a CLOB field.
[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service
(72000/1461) ORA-01461: can bind a LONG value only for insert into a LONG column
"
ORA-01461: can bind a LONG value only for insert into a LONG column

It doesn’t throw an error when the data is short( like 5- 10 lines ), but throws an error if it is bit long data( Not really a large volume). I tried inserting the same manually into db and I am able to insert it .

In our adapter service we have the field as CLOB and I have selected the Input field as java.lang.string

I am using JDBC Adapter Version 9.10 and with Fix Level JDBC_9.10_Fix1

I am using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

2

The LONG and LONG RAW datatypes have been deprecated and the easiest solution to the ORA-01461 error is to change the column datatype to as CLOB.

Please share the screenshots of the JDBC input and output data types from Designer.

Also, make sure install the latest fix levels for your JDBC adapter version.