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

Oracle Community | 2962424 | 1 year ago
  1. 0

    When user clicks on Create Expense Report in self service page gives Error

    Oracle Community | 1 year ago | 2962424
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  2. 0

    issue addding custom fields(from custom table) to the standard page

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

    Automated exception search integrated into your IDE

  4. 0

    issue addding custom fields(from custom table)

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

    Extending View object on a Page

    Oracle Community | 7 years ago | 712742
    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:: 1

    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.getRowCount
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:688)
    3. oracle.jbo.server.ViewRowSetImpl.getRowCount(ViewRowSetImpl.java:1932)
    4. oracle.jbo.server.ViewObjectImpl.getRowCount(ViewObjectImpl.java:6050)
    4 frames
  6. oracle.apps.ap
    HeaderCO.processRequest
    1. oracle.apps.ap.oie.webui.HeaderCO.processRequest(HeaderCO.java:279)
    1 frame
  7. 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.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
    4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
    9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
    14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    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.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    24. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    25. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2620)
    26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
    27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    28 frames
  8. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:212)
    1 frame
  9. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  10. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    3 frames
  11. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  12. com.evermind.server
    ServletRequestDispatcher$2.oc4jRun
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
    3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
    5 frames
  13. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  14. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    2 frames
  15. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:221)
    1 frame
  16. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  17. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    3 frames
  18. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  19. com.evermind.server
    ServletRequestDispatcher$2.oc4jRun
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
    3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
    5 frames
  20. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  21. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    2 frames
  22. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:221)
    1 frame
  23. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  24. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    3 frames
  25. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  26. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  27. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    1 frame
  28. com.evermind.server
    EvermindFilterChain.doFilter
    1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    1 frame
  29. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
    1 frame
  30. com.evermind.server
    AJPRequestHandler.run
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
    3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
    4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
    5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
    6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
    6 frames
  31. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  32. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  33. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame