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

Oracle Community | Pradeep Navin Kumar | 3 years ago
  1. 0

    JBO-27122: SQL error during statement preparation Error

    Oracle Community | 3 years ago | Pradeep Navin Kumar
    java.sql.SQLException: Missing IN or OUT parameter at index:: 6
  2. 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
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 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
  5. 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

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

    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:3754)
    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:3674)
    5 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    1 frame
  7. oracle.apps.irc
    IrcOfferSearchVOImpl.executeQuery
    1. oracle.apps.irc.offers.server.IrcOfferSearchVOImpl.executeQuery(IrcOfferSearchVOImpl.java:160)
    1 frame
  8. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.queryDataInternal(OAWebBeanBaseTableHelper.java:1278)
    2. oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.queryData(OAWebBeanBaseTableHelper.java:1139)
    3. oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean.queryData(OAAdvancedTableBean.java:450)
    4. oracle.apps.fnd.framework.webui.OAQueryHelper.executeQueryFromSearchCache(OAQueryHelper.java:7759)
    5. oracle.apps.fnd.framework.webui.OAQueryHelper.processRequestAfterController(OAQueryHelper.java:682)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:658)
    7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    8. oracle.apps.fnd.framework.webui.OAQueryHelper.processRequest(OAQueryHelper.java:563)
    9. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
    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.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
    15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    19. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
    20. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    23. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    24. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    25. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    29. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    30. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    31. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2620)
    32. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
    33. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    34. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    34 frames
  9. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:212)
    1 frame
  10. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  11. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    3 frames
  12. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  13. com.evermind.server
    ServletRequestDispatcher$2.oc4jRun
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
    5 frames
  14. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  15. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    2 frames
  16. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:221)
    1 frame
  17. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  18. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    3 frames
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  20. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  21. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    1 frame
  22. com.evermind.server
    EvermindFilterChain.doFilter
    1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    1 frame
  23. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
    1 frame
  24. com.evermind.server
    AJPRequestHandler.run
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
    6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
    6 frames
  25. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  26. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  27. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame