You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Wilberto Montoya <wi...@ec-red.com> on 2005/07/21 02:22:48 UTC

Mapping SP to Beans in oracle

Hi i have two questions about Oracle (yes, i know i'm not the only ;) ), but
is posible map an oracle cursor to a class like a java bean only changing
the XML file (without typehandler) and is posible map more than one cursor?

thank you

  <parameterMap id="clientParameters" class="map" >
>        <parameter property="result" jdbcType="ORACLECURSOR" mode="OUT"/>
>        <parameter property="maxRows" jdbcType="VARCHAR"
javaType="java.lang.String" mode="IN"/>
>    </parameterMap>
>    <procedure id="getClientListProc" resultMap="clientResult"
parameterMap="clientParameters">
>        {?= call abc.CLIENT_VIEW_PKG.client_result_list_f(?)}
>    </procedure>