[mybatis] out변수가 있는 프로시저 호출

/* ServiceImpl */
regMap.put("p_in1","값1");
regMap.put("p_in2","값1");
regMap.put("p_out1","");
regMap.put("p_out2","");
regMap.put("p_out3","");

VO.명칭(regMap)


/* xml */
<select id="명칭" resultType="hashMap" statementType="callable">
    call 패키지명.프로시저명
    (
        #{p_in1},
        #{p_in2},
        #{p_out1, mode=OUT, jdbcType=VARCHAR},
        #{p_out2, mode=OUT, jdbcType=VARCHAR},
        #{p_out3, mode=OUT, jdbcType=VARCHAR}
    )        
</select>

/* ServiceImpl */
regMap.put("p_in1","값1");
regMap.put("p_in2","값1");
regMap.put("p_out1","");
regMap.put("p_out2","");
regMap.put("p_out3","");

VO.명칭(regMap)


/* xml */
<select id="명칭" resultType="hashMap" statementType="callable">
    call 패키지명.프로시저명
    (
        #{p_in1},
        #{p_in2},
        #{p_out1, mode=OUT, jdbcType=VARCHAR},
        #{p_out2, mode=OUT, jdbcType=VARCHAR},
        #{p_out3, mode=OUT, jdbcType=VARCHAR}
    )        
</select>