JDBC Receiver Error while inserting

[former_member207623]

Hi All,

I have got one error at reaching DB here am  doing inserting the data into two different tables.. showing the error below :

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PROC.BOATING_INFO' (structure 'CHARS_BOATING_INFO_INSERT_STATEMENT'): java.sql.SQLException: ORA-12899: value too large for column "PROC"."BOATING_INFO"."TOTAL_AB" (actual: 13, maximum: 5)

Can  you please clarify me why its getting  ... please let me know solution this.

Thanks Kishore

[Former Member]

Hello,

The error is clearly indicating that the maximum permissible length of "TOTAL_AB" field is 5 and u have passed 13 length value?

So correct the same and then check.

Thanks

Amit Srivastava