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

Oracle Community | 1498181 | 3 years ago
  1. 0

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

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

    Missing IN or OUT parameter at index...

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

    clearing a results table

    Oracle Community | 8 years ago | 646789
    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

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

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

    how to dynamic pass values to LOV

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

    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:112)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
      3. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1715)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3322)
      5. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3372)
      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(OAViewObjectImpl.java:4537)
      1 frame
    5. oracle.jbo.server
      ViewObjectImpl.first
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:687)
      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:2827)
      7. oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5724)
      7 frames
    6. oracle.apps.po
      PoBaseAMImpl.executeServerCommand
      1. oracle.apps.po.setup.server.PurchasingOptionsSvrCmd.setContextAttr(PurchasingOptionsSvrCmd.java:1128)
      2. oracle.apps.po.setup.server.PurchasingOptionsSvrCmd.initPage(PurchasingOptionsSvrCmd.java:263)
      3. oracle.apps.po.setup.server.PurchasingOptionsSvrCmd.execute(PurchasingOptionsSvrCmd.java:121)
      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:585)
      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:594)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1155)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:962)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:929)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:653)
      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:962)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:929)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:653)
      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:2490)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1888)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
      18 frames
    11. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:216)
      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:335)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      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:719)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
      5 frames
    16. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      1 frame
    17. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
      2 frames
    18. Unknown
      _RF._jspService
      1. _RF._jspService(_RF.java:225)
      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:335)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      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:318)
      1 frame
    26. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
      6 frames
    27. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
      4 frames
    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:595)
      1 frame