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

Oracle Community | fred.jiang | 4 years ago
  1. 0

    help.define purchasing options

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

    Automatically Setting a Status following an Action in SSHR - Qualifications

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

    JBO-27122: SQL error during statement preparation

    Oracle Community | 4 years ago | 887587
    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

    Help deleting VO substitution

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

    iRecruitment page erorr it's urgent.

    Oracle Community | 5 years ago | Srini-999
    java.sql.SQLException: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00118: Warning: undefined entity "nbsp" Error at line 8 ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 414 ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 428 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

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

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
    4. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
    5. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
    6. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1738)
    7. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3382)
    8. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
    9. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    9 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:4559)
    1 frame
  5. oracle.jbo.server
    ViewObjectImpl.first
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:688)
    3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657)
    4. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634)
    5. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1474)
    6. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2828)
    7. oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5792)
    7 frames
  6. oracle.apps.po
    PoBaseAMImpl.executeServerCommand
    1. oracle.apps.po.setup.server.PurchasingOptionsSvrCmd.setContextAttr(PurchasingOptionsSvrCmd.java:1206)
    2. oracle.apps.po.setup.server.PurchasingOptionsSvrCmd.initPage(PurchasingOptionsSvrCmd.java:276)
    3. oracle.apps.po.setup.server.PurchasingOptionsSvrCmd.execute(PurchasingOptionsSvrCmd.java:131)
    4. oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)
    4 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  8. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
    2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
    2 frames
  9. oracle.apps.po
    PurchasingOptionsCO.processRequest
    1. oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
    2. oracle.apps.po.setup.webui.PurchasingOptionsCO.processRequest(PurchasingOptionsCO.java:141)
    2 frames
  10. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
    18 frames