Re: Truncate Table Not Allowed in PL/SQL?

I'm surprised the statement worked at all in a stored procedure. Truncate is a DDL command. You may have to use DBMS_SQL and pass the truncate command to it to make it work.

Mark

Hi wrote in message <7ha3e0$isj$1_at_nnrp1.deja.com>...
>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 Wed May 12 1999 - 03:10:51 CDT