Yes you can, you need to look into ref cursors. If you grab oracle's dot net
provider you will find examples of how to do this.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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:41:55 CDT
