On 8 Apr 2002, djmuttart_at_gov.pe.ca 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?
Along with other thoughts, a temporary table in Oracle should be created
and left around. The data inserted into it is session specific, but
unlike #temps in SQLServer, the ddl should be executed along with all of
your other ddl. Never execute a create global temporary table in an
application proc. Use them to insert into only when you desperately
need to. Oracle will usually perform the set logic you are trying to
perform better than you can.
--
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Mon Apr 08 2002 - 21:13:14 CDT
