RE: Oracle ref cursors

2006-02-10 Thread March, Andres
PROTECTED] Subject: Re: Oracle ref cursors Hmmm...ok. Here's what I'd like to see in a solution: * No dependency upon Oracle (like you've said). * ResultSet types should be supported in both OUT parameters, as well as result set columns (ick). * The regular result set returned by a select

Re: Oracle ref cursors

2006-02-09 Thread Clinton Begin
So the assumptions made here are: * There can be only one out parameter of type ResultSet * The default result set (possibly returned from a SELECT) is lost, as it's overidden by the ResultSet parameter. Seems a bit hackey, but I'm interested in everyone else's opinion. ClintonOn 2/9/06, Sven

Re: Oracle ref cursors

2006-02-09 Thread Sven Boden
There can be more than 1 out result sets, Michael's testcases on the wiki show that. Will check the second bullet tomorrow, we can probably find a way around it it should also be just a resultset (but I vaguely remember some problems with it from past experiments). Sven Clinton Begin

Re: Oracle ref cursors

2006-02-09 Thread Clinton Begin
Yep. I agree on the need. Just being cautious about the implementation.Cheers,ClintonOn 2/9/06, Sven Boden [EMAIL PROTECTED] wrote:In case anyone is interested in having a look, I uploaded the patch to the patch to the

Re: Oracle ref cursors

2006-02-09 Thread Clinton Begin
Hmmm...ok. Here's what I'd like to see in a solution: * No dependency upon Oracle (like you've said). * ResultSet types should be supported in both OUT parameters, as well as result set columns (ick). * The regular result set returned by a select statement or procedure should not be