Error while inserting to Oracle DB from IIB

Question

I have a WMB application (v8) running on AIX server that makes a jdbc connection for inserting to Oracle 9 database. Now, I am migrating this to IIB(v10) running on LINUX server to update the same database. The same Insert query is throwing error in the LINUX server.

The error being shown up is:

Error DescrptionORA-01461: can bind a LONG value only for insert into a LONG column

My query is:

INSERT INTO
EVENT_DATA(
    SEQUENCEID,
    CUSTOMERNUMBER,
    DATETIME,
    DEBTORNUMBER,
    ENDUSERID,
    PREMISENUMBER,
    REPORTEVENTID,
    REQUESTID,
    SOURCECLIENTID,
    SUCCESSINDICATOR) 
VALUES(
    73842,
    100,
    2017-09-16,
    10064393,
    Breeze1,
    303746429,
    AAMP,
    1006,
    O,
    N)

PS: There is nothing wrong/mismatch in column type/data as same query is executing successfully. I could not understand what is wrong with my IIB10 application running on Linux.

Answer 1

can bind a LONG value only for insert into a LONG column

The above error comes because LONG and LONG RAW datatypes have been deprecated in Oracle DB reference.

The solution for this could be to change your datatype from LONG to CLOB.

Edit:

The above error may be caused by exceeding the limit of the varchar or mismatch in size of varchar. try matching size of other datatypes too. i doubt the varchar size causing the above issue. due to size difference between varchar and varchar2