CREATE PROCEDURE `proc_use_points`(
IN `expendId` VARCHAR(20),
OUT `result` VARCHAR(100)
)
set @p_in='1395553661679095809';
set @p_out='';
-- mysql工具直接调用
CALL `procUsePoints`(@p_in, @p_out)
<select id="procUsePoints" resultType="java.lang.String" parameterType="java.lang.String" statementType="CALLABLE">
{call proc_use_points(
#{expendId,jdbcType=VARCHAR,mode=IN},
#{result,jdbcType=VARCHAR,mode=OUT}
)}
</select>