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


Solutions on the web

Solution icon of oraclecommunity
via Oracle Community by 2712224, 1 year ago
Missing IN or OUT parameter at index:: 1

Solution icon of github
Missing IN or OUT parameter at index:: 1

Solution icon of github
Missing IN or OUT parameter at index:: 1

Solution icon of oraclecommunity
via Oracle Community by 797277, 1 year ago
Missing IN or OUT parameter at index:: 1

Solution icon of oraclecommunity
via Oracle Community by user10702579, 1 year ago
Missing IN or OUT parameter at index:: 1

Solution icon of oraclecommunity
Missing IN or OUT parameter at index:: 1

Solution icon of oraclecommunity
via Oracle Community by MaheshB, 1 year ago
Missing IN or OUT parameter at index:: 1

Solution icon of oraclecommunity
Missing IN or OUT parameter at index:: 1

Solution icon of stackoverflow
Missing IN or OUT parameter at index:: 1

Solution icon of web
Missing IN or OUT parameter at index:: 1

Stack trace

java.sql.SQLException: Missing IN or OUT parameter
at index:: 1
	at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
	at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
	at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
	at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
	at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
	at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
	at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4566)
	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:696)
	at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2654)
	at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)
	at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1471)
	at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2836)
	at oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5831)
	at oracle.apps.fnd.wf.worklist.webui.NtfDetailsControlsCO.processRequest(NtfDetailsControlsCO.java:285)
	at xxbt.oracle.apps.fnd.wf.worklist.webui.XxbtNtfDetailsControlsCO.processRequest(XxbtNtfDetailsControlsCO.java:40)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1218)
	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2742)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1971)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:558)
	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:446)
	at _pages.__oa._jspService(__oa.java:233)
	at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
	at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
	at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
	at weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)
	at _pages.__oa._jspService(__oa.java:246)
	at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
	at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
	at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
	at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
	at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
	at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
208 more bugmates