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

Oracle Community | 594196 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    Oracle Community | 6 years ago | 594196
    java.sql.SQLException: ORA-01007: variable not in select list
  2. 0

    Error: while preparing dynamic sql

    Oracle Community | 8 years ago | 654564
    java.sql.SQLException: ORA-01007: variable not in select list
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    error while extending seeded page VO ORA-01007: variable not in select list

    Oracle Community | 7 years ago | 695234
    java.sql.SQLException: ORA-01007: variable not in select list
  5. 0

    OAF Extensions extended the HzPuiOrgOverviewVO

    Oracle Community | 1 decade ago | 101530
    java.sql.SQLException: ORA-01007: variable not in select list

  1. rp 1 times, last 3 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01007: variable not in select list

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
    4 frames
  5. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
    4 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4507)
    1 frame
  7. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
    3. oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
    4. oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3326)
    5 frames
  8. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
    1 frame
  9. oracle.apps.icx
    ReceiveItemsAMImpl.initQuery
    1. oracle.apps.icx.por.rcv.server.ReceiveItemsVOImpl.executeQuery(ReceiveItemsVOImpl.java:113)
    2. oracle.apps.icx.por.rcv.server.ReceiveItemsAMImpl.initQuery(ReceiveItemsAMImpl.java:165)
    2 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  11. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
    2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)
    2 frames
  12. oracle.apps.icx
    RcvSrchCO.processRequest
    1. oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458)
    2. oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67)
    2 frames
  13. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
    18 frames
  14. oa_html
    _OA._jspService
    1. oa_html._OA._jspService(_OA.java:84)
    1 frame
  15. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  16. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  17. oracle.jsp
    JspServlet.service
    1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
    2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
    3. oracle.jsp.JspServlet.service(JspServlet.java:156)
    3 frames
  18. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  19. oracle.jsp.provider
    Jsp20RequestDispatcher.forward
    1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
    1 frame
  20. oracle.jsp.runtime
    OraclePageContext.forward
    1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
    1 frame
  21. oa_html
    _OA._jspService
    1. oa_html._OA._jspService(_OA.java:94)
    1 frame
  22. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  23. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  24. oracle.jsp
    JspServlet.service
    1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
    2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
    3. oracle.jsp.JspServlet.service(JspServlet.java:156)
    3 frames
  25. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  26. oracle.jsp.provider
    Jsp20RequestDispatcher.forward
    1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
    1 frame
  27. oracle.jsp.runtime
    OraclePageContext.forward
    1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
    1 frame
  28. oa_html
    _OA._jspService
    1. oa_html._OA._jspService(_OA.java:94)
    1 frame
  29. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  30. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  31. oracle.jsp
    JspServlet.service
    1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
    2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
    3. oracle.jsp.JspServlet.service(JspServlet.java:156)
    3 frames
  32. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  33. org.apache.jserv
    JServConnection.run
    1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
    2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
    2 frames
  34. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:534)
    1 frame