Re: stored procedure

Don't. Bad idea. You don't usually need to do that in Oracle. (maybe less than 1% of the time) Just do the operation directly and don't use temp tables, readers don't block writers and writers don't block readers. While there are ways to dynamically create a table in Oracle or have a temp table you will kill performance (at least the dynamically created table will). Oracle and Sybase are different.

Look in the docs at global temporary tables if we can't persuade you to not use temp tables.
Jim

"Justin Muttart" <djmuttart_at_gov.pe.ca> wrote in message news:fabfe70c.0204080601.4533d5a_at_posting.google.com...
> I'm trying to create a local temp table in my stored procedure. I've
> tried using the Sybase line of code (DECLARE LOCAL TEMPORARY TABLE
> CORP_VEHICLE-TEMP)This doesn't seem to work. Is there away of properly
> executing a temp table within a stored procedure? My last effort was
> using the statement (EXEC SQL DECLARE table TABLE) and I received
> compile error:
>
> PLS-00103: Encountered the symbol "DECLARE" when expecting one of the
> following:
>
> begin function package pragma procedure subtype type use
> <an identifier> <a double-quoted delimited-identifier>
>
> Can anyone help me with this or can it be done?
Received on Mon Apr 08 2002 - 09:48:38 CDT