Thanks Niall.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3e9582b4$0$4860$ed9e5944_at_reading.news.pipex.net...
> 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:47:00 CDT
