Drop Temp Table

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.

Never mind. I figured it out. But now I am trying insert data into temp table and it's not working.

sqlstmt := 'insert into env_description(env_desc) values ('(1) used black in color wallet')';
execute immediate sqlstmt;


Error:

PLS-00103: Encountered the symbol "(" when expecting one of the
* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like LIKE2_ LIKE4_ LIKEC_ between into using || multiset bulk
member SUBMULTISET_

Any idea what is wrong with my statement?

Thanks.

You need to escape the ' character

sqlstmt := 'insert into env_description(env_desc) values (''(1) used black in color wallet'')';
execute immediate sqlstmt;