My Oracle Support Banner

java.sql.sqlexception Numeric Overflow When Adding Attachment in iStore (Doc ID 2424701.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

Oracle iStore - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Issue reproducible with below steps:

1. Add Item to cart
2. Checkout
3. On the Billing page, enter the PO number and attach any document, it throws Application Error with errorstack -

java.sql.SQLException: Numeric Overflow
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java:4602)
at
oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:536)
at
oracle.apps.ibe.shoppingcart.quote.Attachment.listAttachments(Attachment.java
:374)
at
_oa__html._ibeCScdListAttchTable._jspService(_ibeCScdListAttchTable.java:155)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.