java调用存储过程出错

[minsheng0825]

create or replace procedure pro_update_timeout_member(res out varchar2) is
begin
       declare
       cursor c_hy_member
       is
       select t.memberid,t.rzenddate  from hy_member t where t.status = '3' and t.loginname='ms_001';
       c_row c_hy_member%rowtype;
begin
       for c_row in c_hy_member loop
        if(sysdate > c_row.rzenddate) then
        update hy_member set status = '7' where memberid=c_row.memberid;
        end if;
       end loop;
       res := 'ok';
       exception
        when others then
          res := 'exception happend.' || sqlcode || sqlerrm;
          rollback;
          return;
end;
end pro_update_timeout_member;

上面是我的存储过程
用mybatis调用我的存储过程

<select id="updateMemberTimeOut" statementType="CALLABLE" parameterType="Map">
		<![CDATA[{CALL PRO_UPDATE_TIMEOUT_MEMBER(#{result, mode = OUT,jdbcType=VARCHAR })}]]>
	</select>

然后通过spring定时器调用此方法

/**
	 * 修改认证到期会员状态
	 */
	public void updateMemberTimeOut(){
		try {
			memberService.updateMemberTimeOut();
			log.info("1160001更新会员状态成功！");
		} catch (Exception e) {
			log.error("1260001更新会员状态！" + e);
			e.printStackTrace();
		}
	}

定时器执行时会报错，但是数据库的数据已经修改成功，但是控制台会有错误日志打印

[LVL:INFO] [scheduler_Worker-1] sqltiming.sqlTimingOccured(330) | 
    {CALL PRO_UPDATE_TIMEOUT_MEMBER('<OUT>')}  {executed in 13 msec}
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.NullPointerException
### The error may exist in com/lvjin/orm/member/MemberMapper.xml
### The error may involve com.lvjin.mapper.member.MemberMapper.updateMemberTimeOut-Inline
### The error occurred while setting parameters
### SQL: {CALL PRO_UPDATE_TIMEOUT_MEMBER(?)}
### Cause: java.lang.NullPointerException
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:368)
	at $Proxy15.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at $Proxy59.updateMemberTimeOut(Unknown Source)
	at com.lvjin.service.member.MemberServiceImpl.updateMemberTimeOut(MemberServiceImpl.java:1004)
	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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
	at $Proxy82.updateMemberTimeOut(Unknown Source)
	at com.lvjin.job.ProductScheduler.updateMemberTimeOut(ProductScheduler.java:141)
	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:269)
	at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
	at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.NullPointerException

请大神们帮忙看看，不胜感激！

[静山晚风]

空指针是不是 res是空的?

[minsheng0825]

引用 1 楼 jintianhen1 的回复:

空指针是不是 res是空的?

res不是空，我bebug存储过程的时候可以看到res的值

[静山晚风]

存储过程本身没问题吧 这句

       res := 'ok';
       exception
        when others then
          res := 'exception happend.' || sqlcode || sqlerrm;
          rollback;
          return;

[静山晚风]

可以参考 mybatis 调用 procedure api http://www.mybatis.org/mybatis-3/sqlmap-xml.html