java.sql.SQLException: ORA-01008: not all variables bound

orafaq.com | 9 months 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

    Seeded Page is erroring out in JDeveloper

    Oracle Community | 1 decade ago | Adarsh Kumar
    java.sql.SQLException: ORA-01008: not all variables bound
  2. 0

    Bind variable setting for standalone stackLayout VO region

    Oracle Community | 1 decade ago | 229220
    java.sql.SQLException: ORA-01008: not all variables bound
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Error on extending view object

    Oracle Community | 1 decade ago | 492297
    java.sql.SQLException: ORA-01008: not all variables bound
  5. 0

    Problem in using LOV's (List of values)

    Oracle Community | 1 decade ago | 554681
    java.sql.SQLException: ORA-01008: not all variables bound

  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-01008: not all variables bound

    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:589)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2559)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2950)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:582)
    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.hasNext
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:538)
    3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2369)
    4. oracle.jbo.server.ViewRowSetIteratorImpl.hasNext(ViewRowSetIteratorImpl.java:1567)
    5. oracle.jbo.server.ViewRowSetImpl.hasNext(ViewRowSetImpl.java:2332)
    6. oracle.jbo.server.ViewObjectImpl.hasNext(ViewObjectImpl.java:5335)
    6 frames
  8. oracle.apps.per
    EmpAddressesCO.processRequest
    1. oracle.apps.per.selfservice.hrviews.webui.EmpAddressesCO.processRequest(EmpAddressesCO.java:46)
    1 frame
  9. 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.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
    4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
    7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
    9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
    12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
    14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
    16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
    17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
    18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    19. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
    21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
    22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
    23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
    24. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    25. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2335)
    26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1734)
    27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
    28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
    28 frames
  10. _oa__html
    _OA._jspService
    1. _oa__html._OA._jspService(_OA.java:85)
    1 frame
  11. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  12. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  13. 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
  14. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  15. 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
  16. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame