[ibatis] sql문 예제5 procedure

[ibatis] sql문 예제5 procedure 

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="sync">

  <parameterMap class="map" id="paramssss">

    <parameter javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" property="gubun" />

    <parameter javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" property="hakbun" />

    <parameter javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" property="executer_id" />

    <parameter javaType="java.lang.Integer" jdbcType="INTEGER" mode="OUT" property="insert_cnt" />

    <parameter javaType="java.lang.Integer" jdbcType="INTEGER" mode="OUT" property="update_cnt" />

    <parameter javaType="java.lang.Integer" jdbcType="INTEGER" mode="OUT" property="nonmap_cnt" />

  </parameterMap>

  

  <procedure id="sync.ssa" parameterMap="paramssss">{call U_I_SA ( ?, ?, ?, ?, ?, ? )}</procedure>

</sqlMap>

[ibatis] sql문 예제5 procedure