drop table doesn't work
In a stored procedure I have a piece of code like this:
CREATE PROCEDURE <proc_name>( <parameters>)
RETURNS INTEGER;
.
.
SELECT <some fields>
FROM <tables>
INTO TEMP tmp1;
.
.
<some code here>
.
.
DROP TABLE tmp1;
END PROCEDURE;
But, the "DROP TABLE" does NOT work and when I use this
stored procedure in a query in isql, it complains that:
tmp1 already exists.
Any help will be appreciated.
Sent via Deja.com http://www.deja.com/
Before you buy.