I am doing something like this:
<procedure id="getUsage" parameterMap="getUsageCall"
resultMap="select-usage-object1,select-usage-object2">
{call test_friends (?)}
</procedure>
as you see we have two resultMaps. I think thats the way to do it. But maybe
someone Senior can help us both...
On Nov 26, 2007 5:25 AM, <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> i'm using SQL Server too. Stored procedures returning multiple resultSet
> works, but I can only map the first resultSet into a resultMap. ¿How do you
> map the multiple resultSets?
>
> I can't find the sintax to do this.
>
> Thanks
>
> Angel
>
> ------------------------------
> *De:* bhaarat Sharma [mailto:[EMAIL PROTECTED]
> *Enviado el:* domingo, 25 de noviembre de 2007 22:07
> *Para:* [email protected]
> *Asunto:* iBatis with Oracle stored procs (multiple resultsets)
>
> Hi
>
> I am fairly new to iBatis. We are currently using iBatis with java and MS
> sql server. Stored procedures returning multiple resultMaps is working fine
> for us right now.
>
> However, we are going to be switching to oracle soon and As you know
> oracle has RF Cursors when it comes to returning multiple resultsets from
> stored procs. I am just wondering if there are known problems with this
> approach ?
>
> I am going to be trying this very soon but just wanted to know if some of
> you out there are already aware of some known hiccups.
>
> Thanks
>
> --
> -bhaarat
>
--
-bhaarat
