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;
}