Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate in stored procedure
On Tue, 29 Dec 1998 20:21:06 GMT, andrewf_at_jaredgroup.com
wrote:
>and got compilation error. It seems the pl/sql does not recognize the Truncate
>syntax. Should I change some configure parms or other solutions?
TRUNCATE is considered a DDL statement. To execute it from PL/SQL, you will need to use the DBMS_SQL package.
Jonathan Received on Thu Dec 31 1998 - 18:20:10 CST