All,

I have stored procedure in SQL Server that I need to emulate in Oracle. The procedure creates a temporary table with an identity field, loads data into the temp table, then selects a subset to return to a web form.

In SQL Server you create a temp table using:

CREATE TABLE #TempTable
OrderId int IDENTITY,
OtherFields varchar(50))

I am looking for a similar object in Oracle.

TIA

Rex