java.sql.SQLException: ORA-01007: variable not in select list


Solutions on the web

Solution icon of oraclecommunity
ORA-01007: variable not in select list

Solution icon of oraclecommunity
via Oracle Community by 594196, 1 year ago
ORA-01007: variable not in select list

Solution icon of web
ORA-01007: variable not in select list

Solution icon of oraclecommunity
via Oracle Community by 101530, 3 months ago
ORA-01007: variable not in select list

Solution icon of oraclecommunity
via Oracle Community by 654564, 1 year ago
ORA-01007: variable not in select list

Solution icon of oraclecommunity
via Oracle Community by 636095, 1 year ago
ORA-01007: variable not in select list

Solution icon of oraclecommunity
ORA-01007: variable not in select list

Solution icon of oraclecommunity
ORA-01007: variable not in select list

Solution icon of oraclecommunity
via Oracle Community by 558009, 1 year ago
ORA-01007: variable not in select list

Solution icon of oraclecommunity
ORA-01007: variable not in select list

Stack trace

java.sql.SQLException: ORA-01007: variable not in select list
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
	at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2548)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2933)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578)
	at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)
	at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)
	at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)
	at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
	at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4525)
	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
	at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
	at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)
	at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3326)
	at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
	at XXCo.oracle.apps.hxc.selfservice.timecard.webui.XXTmecardsListCO.processFormRequest(XXTmecardsListCO.java:100)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:810)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)
	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
	at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2700)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
	at _OA._jspService(OA.jsp:33)
	at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
	at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
	at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
	at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
	at java.lang.Thread.run(Thread.java:534)

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, 1 month ago
Samebug visitor profile picture
Unknown user
2 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
30 more bugmates