Re: Oracle 8i and temporary tables

morar2000_at_my-deja.com wrote:
>
> In article <399AC342.1A463107_at_Unforgetable.com>,
> Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> > morar2000_at_my-deja.com wrote:
> > >
> > > I am migrating a SQL Server database to ORACLE 8i.
> > > The SQL server database is heavily using stored procedures and
 temporary
> > > tables.
> > > Any idea on how to implement this in ORACLE 8i nice and easy ?
> > >
> > > Thanks.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> > Both stored procedures and temporary tables are available in 8i.
> >
>
> The difference is that a SQL server stored procedure alows me to return
> a result set, while an Oracle procedure does not.
>
> The sql server procedures have a last stament somethyng like
> SELECT * FROM #Temp1.
> Any more suggestions ?
> Thanks

Sure it does. The technique and syntax are just a bit difference. In Oracle you can return a REF_CURSOR or you can use PL/SQL tables. It may involve a learning curve, but it is do-able. Received on Wed Aug 16 2000 - 15:28:52 CDT