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:26:21 CDT
