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 220.127.116.11.0 - 64bit Production