ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From LAZER <lazer...@gmail.com>
Subject Re: Re resultmap for multiple out params in Ibatis - Oracle
Date Tue, 02 Dec 2008 09:32:21 GMT

Thanks for your reply.

For my doubt is if the Procedure has more than on out variable how to
specify the result map/result class.
because 
 <procedure id="DocumentListSearch" resultMap="DocumentListSearch"
parameterMap="theID">
....
</procedure>





Juan Pablo Araya wrote:
> 
> In the same way as you declare the parameter maps:
> 
> <parameterMap id="theID" class="theClass">
>       <parameter property="ClassProperty1" column="PROCEDURE_PARAM"
> direction="Input"/>
>       <parameter property="ClassProperty2" column="PROCEDURE_PARAM"
> direction="Input"/>
>       <parameter property="ClassProperty3"
> column="PROCEDURE_PARAMOUTPUT" direction="Output"/>
>       <parameter property="REFCURSOR" column="REFCURSOR"
> direction="Output" dbType="RefCursor"/>
> </parameterMap>
> 
> Note the Output in the last two parameters. With this in mind, iBatis
> tries to set ClassProperty3 and then tries to map the resulting cursor
> in the named resultmap
> 
> Greetings and sorry for my poor english!
> 
> 
> On Mon, Dec 1, 2008 at 5:18 PM, LAZER <lazermca@gmail.com> wrote:
>>
>> Hi,
>> how to specify the resultmap if the procedure having more than one params
>> in
>> Ibatis.
>> DB - Oracle
>> Platform - .net,cs 2.0
>>
>> For ex: Procedure having one out param as ref cursor and other is number.
>>
>> can you help me.
>> --
>> View this message in context:
>> http://www.nabble.com/Re-resultmap-for-multiple-out-params-in-Ibatis---Oracle-tp20779695p20779695.html
>> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>>
>>
> 
> 
> 
> -- 
> Juan Pablo Araya
> Egresado Mg. Cs. Ing. Inf. & Ing Civil informática
> Universidad Técnica Federico Santa María
> 
> 

-- 
View this message in context: http://www.nabble.com/Re-resultmap-for-multiple-out-params-in-Ibatis---Oracle-tp20779695p20788765.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.


Mime
View raw message