Re: Truncate Table Not Allowed in PL/SQL?

You need to use the Dynamic SQL Package (DBMS_SQL). With this you can place DDL commands (such as Truncate) within a Stored Proc.

Scott Hutchinson
SHutch_at_Globalnet.co.uk

Big Bear wrote:

> yeah same here. they say you can't use DDL in store proc. see replies
> to my post dt 10th may
>
> Hi wrote:
>
> > A one-line stored procedure:
> >
> > CREATE OR REPLACE PROCEDURE x1 as
> > begin
> > truncate table tablex1;
> > end;
> >
> > got this error, 'PLS-00103: Encountered the symbol "TABLE" when
> > expecting one of the following: := . ( @ % ;The symbol ":= was
> > inserted before "TABLE" to continue.'
> >
> > While connected as the same user, I have no problem to execute this
> > truncate command in SQL worksheet.
> >
> > Hi Chan
> >
> > --== Sent via Deja.com http://www.deja.com/ ==--
> > ---Share what you know. Learn what you don't.---
Received on Thu May 20 1999 - 16:37:57 CDT