It isn't a generic question. It is a specific RDBMS question. Oracle
returns result sets via ref cursors and so you can have multiple out
parameters - hence multiple ref cursors. SQLServer is completely different
beast and knows nothing about ref cursors. Oracle!=SQLServer.
Jim
"Axe" <way.too._at_much.spam.com> wrote in message
news:v9b0lnardful37_at_corp.supernews.com...
> Thanks for your response Jim. I realize this is an Oracle newsgroup.
> Miscellaeous to boot. That's why I'm asking such a generic question. As
> I'm sure you realize, as far as I know, SQL returns result sets not ref
> cursors. I don't even know what those are but you can bet your bottom
> dollar I'll be learning about them soon. As long as I can put them to use
> in ADO.NET then I'm happy.
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
> news:hafla.160777$Zo.31672_at_sccrnsc03...
> > Do you mean have a stored procedure that returns 2 ref cursors? Sure
you
> > can do that. This is Oracle not Sql Server.
> > Jim
> >
> > --
> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> > with family. Remove the negative part, keep the minus sign. You can
> figure
> > it out.
> > "Axe" <way.too._at_much.spam.com> wrote in message
> > news:v9atk251eur4b0_at_corp.supernews.com...
> > > Here's a basic question. In SQL 2000 I can have a stored procedure
that
> > > basically states:
> > >
> > > SELECT * FROM Table1
> > > SELECT * FROM Table2
> > >
> > > And the end results will be two separate result sets. I then take
these
> > > result sets and populate a dataset in ADO.NET so that I end up with a
> > multi
> > > table dataset.
> > >
> > > Can this same thing be done in Oracle? Any specific version?
> > >
> > > Thanks, Axe
> > >
> > >
> >
> >
>
>
Received on Thu Apr 10 2003 - 10:12:22 CDT
