ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From PONSON <mailtopon...@yahoo.co.in>
Subject Re: Oracle stored procs returning multiple cursors
Date Mon, 10 Dec 2007 07:20:54 GMT

Hi,

Following is the xml file format,
-----------------------------
<sqlMap namespace="SalesCalendars"> 
    <parameterMap id="setArrayGetRefCursorMap" class="map" >  
        <parameter property="output1" jdbcType="ORACLECURSOR" mode="OUT"/>
    </parameterMap>
     
    <procedure id="set2DArrayGetRefCursor"
parameterMap="setArrayGetRefCursorMap">
         { call scott.set2DArrayGetRefCursor(?) }
    </procedure>
</sqlMap>
------------------------------
The java code is,

------------------------------
Map map = new HashMap();
getSqlMapClientTemplate().queryForObject("set2DArrayGetRefCursor", map);

OracleResultSetImpl resultSet = (OracleResultSetImpl) map.get("output1");
while (resultSet.next()) {
	System.out.println(resultSet.getString(1));
}
resultSet.close();
----------------------------------



omnipresent wrote:
> 
> Hello,
> 
> Can someone please show a sample resultMap xml file which retrieves data
> from oracle stored procs?
> 
> I have stored procs which return multiple resultsets (cursors).  Does
> iBatis
> have a builtin datatype for oracle cursor types?
> 
> Thanks!
> 
> -- 
> -bhaarat
> 
> 
:-):-):-):-/:-(
-- 
View this message in context: http://www.nabble.com/Oracle-stored-procs-returning-multiple-cursors-tp14116818p14248313.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message