TRUNCATE in PL/SQL

Hello,

I want to clear out a temp table at the end of a package. With small amounts of data to delete, "DELETE FROM temp_table" works, but with large amounts, I get rollback space errors. "TRUNCATE table temp_table;" works from SQL*Plus, but I can't compile in pl/sql.

Why can't I compile the TRUNCATE statement in pl/sql code? Is there a better way? Thanks,

jim Received on Fri Apr 07 2000 - 00:00:00 CDT