IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted Fri May 11, 2018 04:11 PM

    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


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: Unable to insert String data into Oracle Clob field using JDBC adapter service

    Posted Sun May 13, 2018 12:27 AM

    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.


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


Related Content