ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Returning Multiple Resultsets from a Stored Procedure
Date Fri, 11 Feb 2005 03:01:19 GMT
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
<Richard.Yee.ctr@osd.pentagon.mil> 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:clinton.begin@gmail.com]
> Sent: Thursday, February 10, 2005 5:06 PM
> To: ibatis-user-java@incubator.apache.org
> 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
> <Richard.Yee.ctr@osd.pentagon.mil> wrote:
> > Clinton,
> > Does iBATIS support even one resultSet (multiple rows) from a Stored
> > Procedure?
> >
> > Thanks,
> >
> > Richard
> >
> >
> > -----Original Message-----
> > From: Clinton Begin [mailto:clinton.begin@gmail.com]
> > Sent: Thursday, February 10, 2005 4:39 PM
> > To: ibatis-user-java@incubator.apache.org
> > 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 <danatten@gmx.net>
> > 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.
> > >
> >
>

Mime
View raw message