java.sql.SQLException: Missing IN or OUT parameter at index:: 3

Oracle Community | 828271 | 5 years ago
  1. 0

    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-271

    Oracle Community | 5 years ago | 828271
    java.sql.SQLException: Missing IN or OUT parameter at index:: 3
  2. 0

    : Missing IN or OUT parameter at index:: 8 at

    Oracle Community | 5 years ago | 802240
    java.sql.SQLException: Missing IN or OUT parameter at index:: 8
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    iExpense - Error Searching for Expense Report

    Oracle Community | 3 years ago | LMartin
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 351
  5. 0

    Filter values in the Multi-list depending on the value in Drop-down list.

    Oracle Community | 6 years ago | 27091988
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1

  1. qavid 1 times, last 5 months ago
18 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

    Missing IN or OUT parameter at index:: 3

    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
    2. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    4. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    4 frames
  3. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
    4 frames
  4. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
    1 frame
  5. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
    2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
    3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
    4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
    5 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    1 frame
  7. oracle.apps.pon
    AccTermsCondnCO.processRequest
    1. oracle.apps.pon.response.creation.webui.AccTermsCondnCO.processRequest(AccTermsCondnCO.java:63)
    1 frame
  8. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    18 frames