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

Oracle Community | 868733 | 5 years ago
  1. 0

    Missing IN or OUT parameter at Index1

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

    Decode using bind variable in SQL

    Oracle Community | 7 years ago | 741371
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  3. 0

    JBO-27122: SQL error during statement preparation

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

    Automated exception search integrated into your IDE

  5. 0

    Error while setWhereClauseParam in Controller with Date Parameter

    Oracle Community | 7 years ago | 703261
    java.sql.SQLException: ORA-01722: invalid number
  6. 0

    Dynamically adding a filter condition to a VO

    Oracle Community | 7 years ago | 741371
    java.sql.SQLException: ORA-00904: "E"."ACCOUNT_NUMBER": invalid identifier

    12 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:: 1

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
      3. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1566)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2996)
      5. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      5 frames
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:857)
      2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
      3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)
      4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      4 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(Unknown Source)
      1 frame
    5. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)
      5 frames
    6. oracle.apps.fnd
      OAViewObjectImpl.executeQuery
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(Unknown Source)
      1 frame
    7. xxcurnx.oracle.apps
      XxcusttransactionCO.processRequest
      1. xxcurnx.oracle.apps.ont.custdtls.server.XxcustdtlsmainAMImpl.passTocusttrxn(XxcustdtlsmainAMImpl.java:166)
      2. xxcurnx.oracle.apps.ont.custdtls.webui.XxcusttransactionCO.processRequest(XxcusttransactionCO.java:33)
      2 frames
    8. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      18 frames