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>