Re: TRUNCATE in PL/SQL

if it is just a temp table, then drop it at the end of the package and create it at the beginning of the package

Jim Bromhal wrote:

> 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