MyBatis 调用Oracle存储过程，使用Map传递参数

1.存储过程（没有return关键字返回结果集，可以通过out输出结果集）

CREATE OR REPLACE Procedure aaa(num In Varchar,Type In Varchar,Name Out Varchar)
As
Begin
If Type='1' then
Select channels Into Name From bdp_bi.xx_test Where nums=num;
Else if Type='2' Then
Select types Into Name From bdp_bi.xx_test Where nums=num;
Else
Name:='错误';
End If;
End If;
End;

2.MyBatis的xml文件

<parameterMap type="java.util.Map" id="paraMap">
<parameter property="num" jdbcType="VARCHAR" mode="IN" javaType="String"/>
<parameter property="type" jdbcType="VARCHAR" mode="IN" javaType="String"/>
<parameter property="name" jdbcType="VARCHAR" mode="OUT" javaType="String"/>
</parameterMap>
<select id="callPro" statementType="CALLABLE" parameterMap="paraMap">
{ call bdp_bi.aaa(?,?,?) }
</select>

3.DAO层(注：返回值为空,从out中取结果集)

void callPro(Map<String, Object> map);

4.service层

public Map<String, Object> callPro(String num,String type){
Map<String, Object> map = new HashMap<String, Object>();
map.put("type", type);
map.put("num", num);
goldProductDao.callPro(map);
System.out.println(map.get("name"));
return map;
}