mybatis 调用oracle 存储过程

1.存储过程

declare status varchar2(100); message varchar2(100); begin test_func(1,status,message ); dbms_output.put_line(status); dbms_output.put_line(message ); end;

2.配置文件

<select id="test_func" parameterType="java.util.Map" statementType="CALLABLE"> {call test_func( #{id,mode=IN,jdbcType=INTEGER} ,#{status,mode=OUT,jdbcType=VARCHAR} ,#{message,mode=OUT,jdbcType=VARCHAR})} </select>

3.java代码

@Override public Map<String, Object> testFunc(PlnJitRequisitionsParam param){ // TODO Auto-generated method stub Map<String, Object> map = new HashMap<String, Object>(); map.put("id", param.getRequisitionId()); this.st_fnd.selectOne(this.statement("test_func"), map); return map; }