You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-cs@ibatis.apache.org by LAZER <la...@gmail.com> on 2008/12/01 21:18:26 UTC

Re resultmap for multiple out params in Ibatis - Oracle

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.

Re: Re resultmap for multiple out params in Ibatis - Oracle

Posted by LAZER <la...@gmail.com>.

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 <la...@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.

Re: Re resultmap for multiple out params in Ibatis - Oracle

Posted by Juan Pablo Araya <ju...@gmail.com>.

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 <la...@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