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

Oracle Community | Sukanya C U | 2 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

    OAF Extensions extended the HzPuiOrgOverviewVO

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

    extending a EO based VO urgent

    Oracle Community | 1 decade ago | 533926
    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 preparing dynamic sql

    Oracle Community | 8 years ago | 654564
    java.sql.SQLException: ORA-01007: variable not in select list

  1. rp 1 times, last 4 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:583)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2548)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2933)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578)
    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:4525)
    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. XXCo.oracle.apps
    XXTmecardsListCO.processFormRequest
    1. XXCo.oracle.apps.hxc.selfservice.timecard.webui.XXTmecardsListCO.processFormRequest(XXTmecardsListCO.java:100)
    1 frame
  10. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:810)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
    4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
    7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
    9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
    12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)
    14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
    16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
    17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
    18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    19. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    20. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2700)
    21. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
    22. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
    23. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
    23 frames
  11. Unknown
    _OA._jspService
    1. _OA._jspService(OA.jsp:33)
    1 frame
  12. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
    1 frame
  13. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
    3 frames
  14. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    1 frame
  15. com.evermind.server
    HttpRequestHandler.run
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
    3. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
    4. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
    5. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
    5 frames
  16. Dough Lea's util.concurrent package
    PooledExecutor$Worker.run
    1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
    1 frame
  17. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:534)
    1 frame