When you replied then that iBATIS can handle a resultset returned by a stored procedure, the stored procedure was being invoked using the executeQuery() method?
Thanks,
Richard
At 07:01 PM 2/10/2005, you wrote:
Nobody mentioned REF_CURSORS. I was strictly talking about a standard resultset being returned from executeQuery().
The last email about using a Custom Type handler is correct. Ref cursors can be supported that way.
Cheers,
Clinton
On Fri, 11 Feb 2005 01:20:00 -0000, Yee, Richard K, CTR,, DMDCWEST <[EMAIL PROTECTED]> wrote: > Clinton, > I guess I'm a little confused then about the current limitations of iBATIS > and stored procedures. I thought I read in the archives that iBATIS didn't > handle REF_CURSORS as an OUT parameter from a stored procedure. > > Please excuse me if my questions are a little ignorant because I haven't > done much work with stored procedures. > > What I need iBATIS to do is be able to get the result set returned by a > stored procedure. > > Thanks, > > Richard > > -----Original Message----- > From: Clinton Begin [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 10, 2005 5:06 PM > To: [email protected] > Subject: Re: Returning Multiple Resultsets from a Stored Procedure > > Absolutely. > > Cheers, > Clinton > > On Fri, 11 Feb 2005 00:49:41 -0000, Yee, Richard K, CTR,, DMDCWEST > <[EMAIL PROTECTED]> wrote: > > Clinton, > > Does iBATIS support even one resultSet (multiple rows) from a Stored > > Procedure? > > > > Thanks, > > > > Richard > > > > > > -----Original Message----- > > From: Clinton Begin [mailto:[EMAIL PROTECTED] > > Sent: Thursday, February 10, 2005 4:39 PM > > To: [email protected] > > Subject: Re: Returning Multiple Resultsets from a Stored Procedure > > > > Nope. Not at this time. > > > > It doesn't fit our single input/single output semantic. > > > > Cheers, > > Clinton > > > > On Mon, 07 Feb 2005 14:02:15 +1100, Dan Batten <[EMAIL PROTECTED]> > > wrote: > > > Gidday, > > > > > > I'm very interested in using iBatis for my next project but have > > > been unable to find any answer to the question: > > > > > > Does iBatis support returning multiple resultsets from one stored > > > procedure? > > > > > > If it does could you please post a simple example. > > > > > > Cheers, > > > Dan. > > > > > >
