mybatis 调用 Oracle 存储过程并接受返回值的示例代码

PROCEDURE P_TEST_MYBATIS(iv_ins1 IN VARCHAR2, --id

                          iv_ins2 IN VARCHAR2, --no

                          ov_res  OUT number --提示信息

                          ) IS

BEGIN

   ov_res := 0;

   select count (1)

     into ov_res

     from jc_zhiydoc t

    where t.zhiy_id = iv_ins1

      and t.zhiy_no = iv_ins2;

EXCEPTION

   WHEN OTHERS THEN

     RAISE;

END ;

< select id = "exec" statementType = "CALLABLE" >

     call   pkg_ck_task.P_TEST_MYBATIS(

         #{iv_ins1},

         #{iv_ins2},

         #{ov_res,jdbcType=INTEGER,mode=OUT}

     )

</ select >

void exec(Map<String,Object> params);

public int exec(){

     Map<String,Object> map = new HashMap<>();

     map.put( "iv_ins1" , "ZIY00007709" );

     map.put( "iv_ins2" , "0103" );

     mapper.exec(map);

     int res =  ( int )map.get( "ov_res" );

     return res;

}