Re: TRUNCATE in PL/SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/07
Message-ID: <955119776.8312.0.pluto.d4ee154e@news.demon.nl>#1/1

This is DDL. DDL doesn't work directly in PL/SQL For DDL you need to use dbms_sql (Oracle 7 and 8.0) or execute immediate (Oracle 8i).
See my previous posts in this week for a wrapping procedure to handle DDL.

Hth,

Sybrand Bakker, Oracle DBA

"Jim Bromhal" <jbromh1_at_gl.umbc.edu> wrote in message news:Pine.SGI.4.10A.B3.10004071007260.15359904-100000_at_umbc9.umbc.edu...
> 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