Basant Mobiya wrote:Hi,
I am getting "Missing IN or OUT parameter at index:: 1" SQL Exception when calling UTIL_ECA_REFRESH() function using spring framework SimpleJdbcCall call.
Using ojdbc14.jar .
public Object executeFunction(String functionName, Map paramters)
{
SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(getJdbcTemplate());
simpleJdbcCall.withFunctionName(functionName);
Object obj = simpleJdbcCall.executeFunction(Object.class, paramters == null ? new HashMap() : paramters);
return obj;
}
Passing the function name as "util_eca_refresh" and parameter as null.
Exception coming-:
[2010-01-13 14:00:00,820] ERROR T="org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-2" X=",,,," JobRunShell
: Job DEFAULT.org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean#1f488f1 threw an unhandled Exception:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'evaluateProactiveWorkflowRules
' on target class [class com.gearworks.service.EventService$$EnhancerByCGLIB$$ecc250d7] failed; nested exception is org.spring
framework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call UTIL_ECA_RE
FRESH()}]; SQL state [99999]; error code [17041]; Missing IN or OUT parameter at index:: 1; nested exception is java.sql.SQLEx
ception: Missing IN or OUT parameter at index:: 1
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodIn
vokingJobDetailFactoryBean.java:269)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [
{? = call UTIL_ECA_REFRESH()}]; SQL state [99999]; error code [17041]; Missing IN or OUT parameter at index:: 1; nested except
ion is java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTrans
lator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTrans
lator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTrans
lator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952)
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985)
at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:368)
at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:353)
at org.springframework.jdbc.core.simple.SimpleJdbcCall.executeFunction(SimpleJdbcCall.java:137)
at com.gearworks.core.service.EntityService.executeFunction(EntityService.java:419)
at com.gearworks.core.service.EntityService$$FastClassByCGLIB$$74470c72.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.gearworks.core.service.EntityService$$EnhancerByCGLIB$$3d966c8d.executeFunction(<generated>)
at com.gearworks.service.EventService.callEcaRefresh(EventService.java:305)
at com.gearworks.service.EventService.evaluateProactiveWorkflowRules(EventService.java:268)
at com.gearworks.service.EventService$$FastClassByCGLIB$$3f8b573c.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.gearworks.service.EventService$$EnhancerByCGLIB$$ecc250d7.evaluateProactiveWorkflowRules(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodIn
vokingJobDetailFactoryBean.java:260)
... 3 more
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.gearworks.util.jdbc.PreparedStatementWrapper$2.execute(PreparedStatementWrapper.java:53)
at com.gearworks.util.jdbc.PreparedStatementWrapper$2.execute(PreparedStatementWrapper.java:50)
at com.gearworks.util.jdbc.StatementMetricsTemplate.invoke(StatementMetricsTemplate.java:36)
at com.gearworks.util.jdbc.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:57)
at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:987)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:936)
... 32 more
Please help me to debug this error.
Is this the real life? Is this just fantasy? Is this a tiny ad?
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
|