ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yusuf" <Yu...@ekalife.co.id>
Subject Ref Cursor Support in iBatis
Date Fri, 20 Jan 2006 01:12:51 GMT
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...


Mime
View raw message