Re: Returning Multiple Resultsets from a Stored Procedure

[Jan Vissers]

I would think you need a custom typehandler. This would/could bring you support for weakly typed ref cursors. What I personally was/am looking for is an example or description how to support strongly typed ones. The latter would be much nicer. -J. Yee, Richard K, CTR,, DMDCWEST 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: 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 <[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: 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 <[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. --  And

<<inline: get.gif>>

<<inline: thunderbird_small.png>>