Java. SQL. SQLException: The IN or OUT parameters are lost IN the index: 1 Solution

Java. SQL. SQLException: The IN or OUT parameter is missing IN the index: 1at oracle. jdbc. driver. databaseError. throwSqlException (DatabaseError. java: 125) at oracle. jdbc. driver. databaseError. throwSqlException (DatabaseError. java: 162) at oracle. jdbc. driver. oraclePreparedStatement. processCompletedBindRow (OraclePreparedStatement. java: 1536) at oracle.jdbc.driver.OraclePreparedStatement.exe cuteInternal (OraclePreparedStatement. java: 2880) Oracle.jdbc.driver.OraclePreparedStatement.exe cuteQuery (OraclePreparedStatement. java: 2926) at com. topcheer. baseData. mvc. action. lcoperator. DBConn. query (DBConn. java: 113) at com. topcheer. baseData. mvc. action. lcoperator. checkUserDao. queryAll (CheckUserDao. java: 43) at com.topcheer.baseData.mvc.action.lcoperator.CheckUserInputAction.exe cute (CheckUserInputAction. java: 91) at org. apache. struts. chain. commands. ser Vlet.ExecuteAction.exe cute (ExecuteAction. java: 58) at org.apache.struts.chain.commands.?actexecuteaction.exe cute (AbstractExecuteAction. java: 67) at org.apache.struts.chain.commands.ActionCommandBase.exe cute (ActionCommandBase. java: 51) at org.apache.commons.chain.impl.ChainBase.exe cute (ChainBase. java: 191) at org.apache.commons.chain.generic.LookupCommand.exe cute (LookupCommand. java: 305) at org. apache. co Mmons.chain.impl.ChainBase.exe cute (ChainBase. java: 191) at org. apache. struts. chain. composableRequestProcessor. process (ComposableRequestProcessor. java: 283) at org. apache. struts. action. actionServlet. process (ActionServlet. java: 1913) at com. topcheer. util. YBTActionServlet. process (YBTActionServlet. java: 16) at org. apache. struts. action. actionServlet. doPost (ActionServlet. java: 462) at javax. servlet. http. httpServl Et. service (HttpServlet. java: 637) at javax. servlet. http. httpServlet. service (HttpServlet. java: 717) at org. apache. catalina. core. applicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 290) at org. apache. catalina. core. applicationFilterChain. doFilter (ApplicationFilterChain. java: 206) at com. topcheer. common. filter. sessionFilter. doFilter (SessionFilter. java: 89) at org. apache. catalina. core. applicatio NFilterChain. internalDoFilter (ApplicationFilterChain. java: 235) at org. apache. catalina. core. applicationFilterChain. doFilter (ApplicationFilterChain. java: 206) at com. topcheer. common. encodingFilter. doFilter (EncodingFilter. java: 69) at org. apache. catalina. core. applicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 235) at org. apache. catalina. core. applicationFilterChain. doFilter (ApplicationFilte RChain. java: 206) at org. apache. catalina. core. standardWrapperValve. invoke (StandardWrapperValve. java: 233) at org. apache. catalina. core. standardContextValve. invoke (StandardContextValve. java: 191) at org. apache. catalina. core. standardHostValve. invoke (StandardHostValve. java: 128) at org. apache. catalina. valves. errorReportValve. invoke (ErrorReportValve. java: 102) at org. apache. catalina. core. standardEngineValve. invo Ke (StandardEngineValve. java: 109) at org. apache. catalina. connector. coyoteAdapter. service (CoyoteAdapter. java: 293) at org. apache. coyote. http11.Http11Processor. process (Http11Processor. java: 849) at org. apache. coyote. http11.Http11Protocol $ Http11ConnectionHandler. process (Http11Protocol. java: 583) at org.apache.tomcat.util.net. JIoEndpoint $ Worker. run (JIoEndpoint. java: 454) at java. lang. thread. run (Thread. java: 619) Java. lang. nullPointerExceptionat com. topcheer. baseData. mvc. action. lcoperator. checkUserDao. queryAll (CheckUserDao. java: 45) at com.topcheer.baseData.mvc.action.lcoperator.CheckUserInputAction.exe cute (CheckUserInputAction. java: 91) at org.apache.struts.chain.commands.servlet.ExecuteAction.exe cute (ExecuteAction. java: 58) at org.apache.struts.chain.commands.?actexecuteaction.exe cute (AbstractExecuteAction. Java: 67) at org.apache.struts.chain.commands.ActionCommandBase.exe cute (ActionCommandBase. java: 51) at org.apache.commons.chain.impl.ChainBase.exe cute (ChainBase. java: 191) at org.apache.commons.chain.generic.LookupCommand.exe cute (LookupCommand. java: 305) at org.apache.commons.chain.impl.ChainBase.exe cute (ChainBase. java: 191) at org. apache. struts. chain. composableRequestProcessor. process (ComposableRequestPro Cessor. java: 283) at org. apache. struts. action. actionServlet. process (ActionServlet. java: 1913) at com. topcheer. util. YBTActionServlet. process (YBTActionServlet. java: 16) at org. apache. struts. action. actionServlet. doPost (ActionServlet. java: 462) at javax. servlet. http. httpServlet. service (HttpServlet. java: 637) at javax. servlet. http. httpServlet. service (HttpServlet. java: 717) at org. apache. catalina. core. applicationFi LterChain. internalDoFilter (ApplicationFilterChain. java: 290) at org. apache. catalina. core. applicationFilterChain. doFilter (ApplicationFilterChain. java: 206) at com. topcheer. common. filter. sessionFilter. doFilter (SessionFilter. java: 89) at org. apache. catalina. core. applicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 235) at org. apache. catalina. core. applicationFilterChain. doFilter (ApplicationFil TerChain. java: 206) at com. topcheer. common. encodingFilter. doFilter (EncodingFilter. java: 69) at org. apache. catalina. core. applicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 235) at org. apache. catalina. core. applicationFilterChain. doFilter (ApplicationFilterChain. java: 206) at org. apache. catalina. core. standardWrapperValve. invoke (StandardWrapperValve. java: 233) at org. apache. catalina. core. standa RdContextValve. invoke (StandardContextValve. java: 191) at org. apache. catalina. core. standardHostValve. invoke (StandardHostValve. java: 128) at org. apache. catalina. valves. errorReportValve. invoke (ErrorReportValve. java: 102) at org. apache. catalina. core. standardEngineValve. invoke (StandardEngineValve. java: 109) at org. apache. catalina. connector. coyoteAdapter. service (CoyoteAdapter. java: 293) at org. apache. coyote. http1 1. http11Processor. process (Http11Processor. java: 849) at org. apache. coyote. http11.Http11Protocol $ Http11ConnectionHandler. process (Http11Protocol. java: 583) at org.apache.tomcat.util.net. JIoEndpoint $ Worker. run (JIoEndpoint. java: 454) at java. lang. thread. run (Thread. java: 619) If this error is caused by an SQL error, you can modify the SQL statement.