Hello, I was wondering about the support for ref cursors in ibatis, and
i stumbled upon this in the ibatis wiki page
(http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+R
EF+CURSOR+Solutions):
<sqlMap>
<typeAlias alias="Employee" type="test.Employee" />
<resultMap id="employee-map" class="Employee">
<result property="name" column="ENAME" />
<result property="employeeNumber" column="EMPNO" />
<result property="departmentNumber" column="DEPTNO" />
</resultMap>
<parameterMap id="single-rs" class="map" >
<parameter property="in1" jdbcType="int"
javaType="java.lang.Integer" mode="IN"/>
<parameter property="output1" jdbcType="ORACLECURSOR"
mode="OUT"/>
</parameterMap>
<procedure id="GetSingleEmpRs" parameterMap="single-rs"
resultMap="employee-map">
{ call scott.example.GetSingleEmpRS(?, ?) }
</procedure>
<parameterMap id="double-rs" class="map" >
<parameter property="in1" jdbcType="int"
javaType="java.lang.Integer" mode="IN"/>
<parameter property="output1" jdbcType="ORACLECURSOR" mode="OUT"
resultMap="employee-map" />
<parameter property="output2" jdbcType="ORACLECURSOR" mode="OUT"
resultMap="employee-map" />
</parameterMap>
<procedure id="GetDoubleEmpRs" parameterMap="double-rs" >
{ call scott.example.GetDoubleEmpRS(?, ?, ?) }
</procedure>
</sqlMap>
I was wondering about what is the source for the procedure
scott.example.GetSingleEmpRS and scott.example.GetDoubleEmpRS, can
someone give me the source for this? thank you...