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 - 09:42:02 CDT
