dcsimg
Bind variable error(Missing IN or OUT)
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   devang_parikh
Posted On:   Monday, July 19, 2004 03:17 AM

age Hi, Can you tell me the reason of this error ? java.sql.SQLException: Missing IN or OUT. I have 3 bind variables in query and last bind variable is used at more than one place in query. I am also passing all the three bind variables' value but still getting above mentioned error. Detail of the same is below mentioned ------------------------------------- I have following where condition for a query of view object (oracle's bc4j framework object) (group_id = :1 )and (event_id = :2 )and ( trunc(schedule_date,'Month') = trunc(to_date(:3,'yyyy-mm-dd'),'Month') OR ( REPEATS='Y' AND to_date(:3,'yyyy-mm-dd') <= REPEATS_UNTIL AND schedule_date <= last_day(to_date(:3,'yyyy-mm-dd'))))    More>>

age Hi, Can you tell me the reason of this error ? java.sql.SQLException: Missing IN or OUT. I have 3 bind variables in query and last bind variable is used at more than one place in query. I am also passing all the three bind variables' value but still getting above mentioned error.
Detail of the same is below mentioned

-------------------------------------


I have following where condition for a query of view object



(oracle's bc4j framework object) (group_id = :1 )and (event_id = :2 )and ( trunc(schedule_date,'Month') = trunc(to_date(:3,'yyyy-mm-dd'),'Month') OR ( REPEATS='Y' AND to_date(:3,'yyyy-mm-dd') <= REPEATS_UNTIL AND schedule_date <= last_day(to_date(:3,'yyyy-mm-dd'))))



I am passing the three bind variables value in following way. Object[] objParam = new Object[3]; objParam[0] = new Integer(this.iGroupId); objParam[1] = new Integer(this.strEventId); objParam[2] = this.dtCurrMonth ; voEventResource.setWhereClauseParams(objParam); voEventResource.executeQuery(); during the execution of last statement i am facing the following error.




GsaSchCalViewResourceEventVO1 04/07/16 07:43:43 [417] Binding param 1: 5 04/07/16 07:43:43 [418] Binding param 2: 30 04/07/16 07:43:43 [419] Binding param 3: 2004-07-01 04/07/16 07:43:43 [420] ViewObject: GsaSchCalViewResourceEventVO1 close single-use prepared statements 04/07/16 07:43:43 [421] QueryCollection.executeQuery failed... 04/07/16 07:43:43 [422] java.sql.SQLException: Missing IN or OUT parameter at index:: 4 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174) at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1555) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2981) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3034) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:665) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:521) --More--at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3200) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:597) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:700) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:638) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3147) at oracle.appsit.gsa.scheduler.client.GSAResourceSchedularMonth.setMonthResourceDetail(GSAResourceSchedularMonth.java: 46) at oracle.appsit.gsa.scheduler.client.GSAResourceSchedularMonth. (GSAResourceSchedularMonth.java:34) at _scheduler._FrameCenter._jspService(_FrameCenter.java:356) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:347) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186) at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------
The above mentioned code is working fine with oc4j9.0.2 application server but when i m deploying the same page on oc4j9.0.4 it is giving above mentioned error. Please suggest me the solution for it.
Thanks, Devang

   <<Less
About | Sitemap | Contact