ORA-12899: value too large for column

[Former Member]

Hello,

the following error occured in jdbc receiver adapter. Would you help me please?

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'LGC_AMBALAJ_HAKEDIS_DETAY' (structure 'STATEMENT2'): java.sql.SQLException: ORA-12899: value too large for column "TFS_DMFK"."AMBALAJ_HAKEDIS_DETAY"."HAREKET_TURU" (actual: 4, maximum: 3)

Thanks in Advance

Nurhan

[Former Member · Accepted solution]

>>java.sql.SQLException: ORA-12899: value too large for column

error cleary signifies that u are trying to insert a value in the cloumn (HAREKET_TURU) greater than its maxxium permissble length..i.e 3

[Former Member]

Thanks for your help. The problem is solved.

Nurhan

[monicabhosale]

Hi

The Field HAREKET_TURU has max field length as 3..but your record has value of length 4..

Test it by passing with field length 3.