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

Oracle Community | 877023 | 5 years ago
  1. 0

    How to pass parameters to view object having oracletext keyword contains

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

    how to add where clause in LOV..?

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

    LOV dynamic where clause Error.

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

    Automated exception search integrated into your IDE

  5. 0

    VO error

    Oracle Community | 7 years ago | 680883
    java.sql.SQLException: Missing IN or OUT parameter at index:: 4
  6. 0

    How to Handle oracle.jbo.SQLStmtException Exception

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

    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
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(Unknown Source)
      2. oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAQueryHelper.handleSubmitButton(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAQueryHelper.processFormRequestAfterController(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OAQueryHelper.processFormRequest(Unknown Source)
      9. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      19. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(Unknown Source)
      20. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(Unknown Source)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      23. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      24. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      25. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      29. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      30. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(Unknown Source)
      31. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
      32. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      33. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      34. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      34 frames