java.sql.SQLException: Invalid column type


Solutions on the web

Solution icon of oraclecommunity
via Oracle Community by 879472, 1 year ago
Invalid column type

Solution icon of oraclecommunity
via Oracle Community by 822827, 1 year ago
Invalid column type

Solution icon of oraclecommunity
via Oracle Community by user621385, 1 year ago
Invalid column type

Solution icon of oraclecommunity
Invalid column type

Solution icon of oraclecommunity
Invalid column type

Solution icon of oraclecommunity
via Oracle Community by 667099, 1 year ago
Invalid column type

Solution icon of stackoverflow
via Stack Overflow by Carl
, 1 year ago
Invalid column type

Solution icon of web
via smartclient.com by Unknown author, 1 year ago
Invalid column type: getDATE

Solution icon of web
Invalid column type

Solution icon of github
Invalid column type

Stack trace

java.sql.SQLException: Invalid column type
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9231)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8812)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9534)
	at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9517)
	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.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:688)
	at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657)
	at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634)
	at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1474)
	at oracle.jbo.server.EntityRowSetIteratorImpl.first(EntityRowSetIteratorImpl.java:145)
	at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2828)
	at oracle.jbo.server.AssociationDefImpl.get(AssociationDefImpl.java:384)
	at oracle.jbo.server.AssociationDefImpl.get(AssociationDefImpl.java:291)
	at oracle.jbo.server.EntityImpl.getAttributeInternal(EntityImpl.java:2151)
	at oracle.apps.fnd.framework.server.OAEntityImpl.getAttribute(OAEntityImpl.java:1367)
	at oracle.apps.fnd.framework.server.OAEntityImpl.getAttributeInternal(OAEntityImpl.java:1348)
	at oracle.apps.po.schema.server.PoDistributionMergeEOImpl.getPoLineLocationMergeEO(PoDistributionMergeEOImpl.java:3287)
	at oracle.apps.po.document.server.PoDistributionsMergeVORowImpl.getPoLineLocationMergeEO(PoDistributionsMergeVORowImpl.java:396)
	at oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelForDestinationTypeRender(PoDistributionsRenderCmd.java:1063)
	at oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelForDestinationType(PoDistributionsRenderCmd.java:1036)
	at oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelAttributesForDistribution(PoDistributionsRenderCmd.java:878)
	at oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelAttributesForRow(PoDistributionsRenderCmd.java:310)
	at oracle.apps.po.common.server.PoTableBaseRenderCmd.prepareSpelAttributesForRange(PoTableBaseRenderCmd.java:171)
	at oracle.apps.po.common.server.PoTableBaseRenderCmd.prepareSpelAttributes(PoTableBaseRenderCmd.java:99)
	at oracle.apps.po.document.server.PoDistributionsRenderCmd.execute(PoDistributionsRenderCmd.java:261)
	at oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)
	at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
	at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
	at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
	at oracle.apps.po.document.order.webui.OrderDistributionsCO.processRequest(OrderDistributionsCO.java:97)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
	at oracle.apps.fnd.framework.webui.OASubTabLayoutHelper.processRequest(OASubTabLayoutHelper.java:433)
	at oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processRequest(OASubTabLayoutBean.java:465)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2497)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1893)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:537)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:425)

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, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 6 months 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
76 more bugmates