Hi,
I am using Jdeveloper 10.1.3.2 to develop an ADF BC JSF 1.2 framework application. I have a form which has page def variables to which I bind my form fields. Once my form is submiitted first time and I catch and throw the error, I enter the correct values and resubmit. Here I always get the error
- Missing IN or OUT parameter at index:: 1
The stack is
11/05/05 11:57:22 java.sql.SQLException: Missing IN or OUT parameter at index:: 1
11/05/05 11:57:22 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
11/05/05 11:57:22 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
11/05/05 11:57:22 at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1587)
11/05/05 11:57:22 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2996)
11/05/05 11:57:22 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
11/05/05 11:57:22 at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:857)
11/05/05 11:57:22 at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
11/05/05 11:57:22 at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)
11/05/05 11:57:22 at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
11/05/05 11:57:22 at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
11/05/05 11:57:22 at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
11/05/05 11:57:22 at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
11/05/05 11:57:22 at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)
11/05/05 11:57:22 at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingIfNeeded(DCJboDataControl.java:827)
11/05/05 11:57:22 at oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:1806)
11/05/05 11:57:22 at oracle.adf.model.binding.DCBindingContainer.internalRefreshControl(DCBindingContainer.java:2494)
11/05/05 11:57:22 at oracle.adf.model.binding.DCBindingContainer.refresh(DCBindingContainer.java:2260)
11/05/05 11:57:22 at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.prepareModel(PageLifecycleImpl.java:99)
11/05/05 11:57:22 at oracle.adf.controller.faces.lifecycle.FacesPageLifecycle.prepareModel(FacesPageLifecycle.java:73)
11/05/05 11:57:22 at ex.view.util.CustomFacesPageLifecycle.prepareModel(CustomFacesPageLifecycle.java:59)
11/05/05 11:57:22 at oracle.adf.controller.v2.lifecycle.Lifecycle$8.execute(Lifecycle.java:210)
11/05/05 11:57:22 at oracle.adf.controller.v2.lifecycle.Lifecycle.executePhase(Lifecycle.java:116)
11/05/05 11:57:22 at oracle.adf.controller.faces.lifecycle.ADFPhaseListener.mav$executePhase(ADFPhaseListener.java:29)
11/05/05 11:57:22 at oracle.adf.controller.faces.lifecycle.ADFPhaseListener$4.after(ADFPhaseListener.java:327)
11/05/05 11:57:22 at oracle.adf.controller.faces.lifecycle.ADFPhaseListener.afterPhase(ADFPhaseListener.java:90)
11/05/05 11:57:22 at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:254)
11/05/05 11:57:22 at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110)
11/05/05 11:57:22 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:213)
11/05/05 11:57:22 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
11/05/05 11:57:22 at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:233)
11/05/05 11:57:22 at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:202)
11/05/05 11:57:22 at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123)
11/05/05 11:57:22 at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103)
11/05/05 11:57:22 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
11/05/05 11:57:22 at ex.view.backingbean.user.ApplicationSessionExpiryFilter.doFilter(ApplicationSessionExpiryFilter.java:123)
11/05/05 11:57:22 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
11/05/05 11:57:22 at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:162)
11/05/05 11:57:22 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:620)
11/05/05 11:57:22 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:369)
11/05/05 11:57:22 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:865)
11/05/05 11:57:22 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:447)
11/05/05 11:57:22 at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:215)
11/05/05 11:57:22 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
11/05/05 11:57:22 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
11/05/05 11:57:22 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
11/05/05 11:57:22 at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
11/05/05 11:57:22 at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
11/05/05 11:57:22 at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
11/05/05 11:57:22 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
11/05/05 11:57:22 at java.lang.Thread.run(Thread.java:595)
Please help
Thanks in advance