stored procedure

From: Justin Muttart <djmuttart_at_gov.pe.ca>
Date: 8 Apr 2002 07:01:41 -0700
Message-ID: <fabfe70c.0204080601.4533d5a@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:01:41 CDT