mybatis 存储过程
GET_NUM(
P_ORDER IN VARCHAR2,
P_ORDER_TYPE IN VARCHAR2,
P_SEC_FLAG IN CHAR,
P_SEC_CODE IN VARCHAR2,
P_YEAR_FLAG IN CHAR,
P_MSG_CODE OUT NUMBER,
P_MSG_INFO OUT VARCHAR2,
P_BILL_NO OUT VARCHAR2
)
这么一个存储过程我在mapper。xml里应该怎么写呢
<select id="getBianHaoByType" statementType="CALLABLE" parameterType="SysSeqsNo" resultType="map" >
call{sys_pkg.get_num(

)}
</select>

[解决办法]

XML code

<select id="getBianHaoByType" statementType="CALLABLE" parameterType="SysSeqsNo" resultType="map" >call{sys_pkg.get_num(#{P_ORDER,mode=IN,jdbcType=VARCHAR}     )}</select>