Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |