java.sql.SQLException: Bigger type length than Maximum

[vishnu_pallamreddy]

Hi All,

My scenario os ECC to JDBC Synchronous.

I am getting below error.

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'amgen_order_processing_pkg.AMGEN_PRICE_ORDER' (structure 'StatementName'): java.sql.SQLException: Bigger type length than Maximum

Why I am getting this error.

what are the possible solutions?

[iaki_vila · Accepted solution]

Hi Vishnu,

The problem seems to be in certain data that the driver can't interpret. The solution more recommended is to upgrade the driver version. Please check this thread OraFAQ Forum: JDeveloper, Java & XML » Re: Bigger type length than Maximum

Regards.

[Former Member]

Hello Vishnu,

In the procedure(in one of the insert/update statements), you have a field in which the value length is greater than the SQL database table field permitted.

Regards,

Souvik