Thank you Sharma. How do you work whith the two result maps when you are programming the API? A java method can only return one result... Can any one confirm me if it's possible to work whith two result maps and how? Thank you
________________________________ De: bhaarat Sharma [mailto:[EMAIL PROTECTED] Enviado el: lunes, 26 de noviembre de 2007 13:45 Para: [email protected] Asunto: Re: iBatis with Oracle stored procs (multiple resultsets) 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] <mailto:[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
