java.sql.SQLException: Invalid column index


Solutions on the web

Solution icon of oraclecommunity
Invalid column index

Solution icon of coderanch
via Coderanch by Atousa Pourdavood, 10 months ago
Invalid column index

Solution icon of oraclecommunity
Invalid column index

Solution icon of oraclecommunity
Invalid column index

Solution icon of oraclecommunity
via Oracle Community by Gaurav Bhardwaj, 1 year ago
Invalid column index

Solution icon of oraclecommunity
via Oracle Community by user10648285, 1 year ago
Invalid column index

Solution icon of stackoverflow
Invalid column index

Solution icon of sakai
via Sakai JIRA by Yi Zhu, 1 year ago
Invalid column index

Solution icon of oraclecommunity
Invalid column index

Stack trace

java.sql.SQLException: Invalid column index
	at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5168)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8098)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
	at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:230)
	at oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
	at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3893)
	at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
	at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:13827)
	at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
	at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
	at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
	at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
	at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
	at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
	at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
	at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
	at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
	at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
	at COTest5.oracle.apps.pos.supplier.webui.XXNWSSuppSummCO.processFormRequest(XXNWSSuppSummCO.java:37)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1214)
	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
	at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2968)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1852)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
3 more bugmates