Re: stored procedure

Don't do it. This technique may be part-and-parcel of your Sybase experience but it has no place in an Oracle stored procedure. We almost never use temp tables due to Oracle's architecture. I have only had one or two reasons to use temp tables of any type in Oracle in the last 10 years.

There are lots of things in Oracle, important things, that do not work the way they do in Sybase. And to the extent that you don't learn what they are and how they work differently you will build insecure, unscalable, poorly performing databases containing corrupt data.

Daniel Morgan

Justin Muttart wrote:

> 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 - 11:18:16 CDT