关于在SSM+quartz定时器调用mysql存储过程中所遇到的错误

BEGIN
#Routine body goes here...
DECLARE err int DEFAULT 0;
DECLARE p_adminId int;
DECLARE p_date VARCHAR(15);
DECLARE p_longCode VARCHAR(50);
DECLARE p_company varchar(50);
DECLARE p_spName VARCHAR(20);
DECLARE p_remark varchar(200);
DECLARE p_date_before_yestday VARCHAR(15);
DECLARE p_count int;
declare continue handler for sqlexception set err=1;
set p_date=date;
set p_date_before_yestday=date_add(p_date, interval -1 day);
START TRANSACTION;

select count(*) from sdk_user_logined where subdate = p_date_before_yestday;

        IF p_count=0 
THEN
insert into sdk_user_logined(sdk_id,imsi,subdate)
select a.sdk_id,a.imsi,p_date_before_yestday from
(select imsi,sdk_id,subtime from sdk_user_record where type = 1
and subtime BETWEEN CONCAT(p_date_before_yestday,' 00:00:00')                         and                         CONCAT(p_date_before_yestday,' 23:59:59')
group by imsi,sdk_id) a where not EXISTS 
(select * from sdk_user_logined sul where sul.imsi = a.imsi and sul.sdk_id = a.sdk_id);
END IF;

        -- 以上是存储过程

        --   我在mapper中调用的时候是这样写的

        <select id="callProcedure" parameterType="String" statementType="CALLABLE">
{   call "存储过程名"(  
    #{date,jdbcType=VARCHAR,mode=IN}
    )}  

</select>

    结果 报错如下：

     org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.lt.center.dao.SdkChannelDayDataMapper.callProcedure'.  It's likely that neither a Result Type nor a Result Map was specified.
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
at com.sun.proxy.$Proxy18.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 com.sun.proxy.$Proxy22.callProcedure(Unknown Source)
at com.lt.center.service.impl.SdkChannelDayDataServiceImpl.generateSdkChannelDayDataAndSdkCpDayData(SdkChannelDayDataServiceImpl.java:161)
at com.lt.center.quartz.countSdkChannelAndSdkCpDayData.execute(countSdkChannelAndSdkCpDayData.java:33)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.lt.center.dao.SdkChannelDayDataMapper.callProcedure'.  It's likely that neither a Result Type nor a Result Map was specified.
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.validateResultMapsCount(DefaultResultSetHandler.java:227)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:150)
at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
... 9 more

    解决：select count(*) into p_count from sdk_user_logined where subdate = p_date_before_yestday;

    count(*) 查出来 作为一个返回值  需要被接受  所以报错

    into 一个变量就行了。