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

Oracle Community | 997553 | 7 months ago
  1. 0

    Customized oracle.apps.ap.oie.server.CreditCardTransactionsVO Vo throws an exception

    Oracle Community | 7 months ago | 997553
    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. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  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
  6. 0

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

    Oracle Community | 7 years ago | 745019
    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:4568)
    1 frame
  5. oracle.jbo.server
    ViewRowSetIteratorImpl.hasNext
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:696)
    3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2654)
    4. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)
    5. oracle.jbo.server.ViewRowSetIteratorImpl.hasNext(ViewRowSetIteratorImpl.java:1788)
    5 frames
  6. oracle.apps.ap
    WebExpensesAMImpl.anyOldCCTrxnsForSelectedCard
    1. oracle.apps.ap.oie.server.WebExpensesAMImpl.anyOldCCTrxnsForSelectedCard(WebExpensesAMImpl.java:1339)
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    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.OAUtility.invokeMethod(OAUtility.java:133)
    3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:799)
    3 frames
  9. oracle.apps.ap
    CCTransactionCO.processRequest
    1. oracle.apps.ap.oie.webui.CCTransactionCO.processRequest(CCTransactionCO.java:44)
    1 frame
  10. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    3. oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:353)
    4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
    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:976)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
    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:976)
    16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
    17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
    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:976)
    21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
    22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
    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:2678)
    26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1960)
    27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
    28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
    28 frames
  11. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:213)
    1 frame
  12. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  13. 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
  14. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  15. 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:308)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
    5 frames
  16. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  17. 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
  18. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:222)
    1 frame
  19. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  20. 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
  21. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  22. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  23. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    1 frame
  24. com.evermind.server
    EvermindFilterChain.doFilter
    1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    1 frame
  25. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
    1 frame
  26. 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
  27. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  28. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  29. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame