Re: Truncate Table Not Allowed in PL/SQL?

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 13 1999 - 08:54:59 CDT