Hi All,

How do you drop a temporary table within a stored procedure?

I have a command that looks like this but it doesn't seem to be working:


sqlstmt := 'drop table env_description';
execute immediate sqlstmt;


Any help is appreciated.

Thanks.