Drop temprary table in stored procedure

siprjua01 · #1 (**permalink**) 11-07-05, 05:15

I have a stored procedure in DDF with a temporary table.
How can i drop a temporary table in a stored procedure with a CURSOR WITH RETURN in the temporary table ?.

gmesturini · #2 (**permalink**) 11-08-05, 04:45

i don't think you can, not in the same SP. the cursor should be a pointer on the table, not a real object containing data. you can drop the table only after you move the data from the table to another destination, by the cursor.

Internet Services

Web Development

Digital Marketing

Consumer Tech