Re: Truncate statement within PL/SQL procedure won't compile!

From: Dave Sutton <dpsutton_at_marchsystems.co.uk>
Date: Thu, 22 Feb 2001 17:42:16 -0000
Message-ID: <973ivc$cef$1@newsreaderm1.core.theplanet.net>

Thanks for your help.

Much appreciated.

Dave

"Dave Sutton" <dpsutton_at_marchsystems.co.uk> wrote in message news:970b4t$ej2$1_at_newsreaderg1.core.theplanet.net...
> Hi,
>
> Has anyone else experienced this?
>
> I'm logged on as the schema owner of the table in question and can
> successfully execute a truncate statement on that table outside of a
PL/SQL
> procedure but as soon as I put the statement inside the procedure, the
> procedure will no longer compile!
>
> The procedure compiles if I change the TRUNCATE to a DELETE statement.
>
> What am I missing??
>
> Thanks in advance.
>
>
> Dave Sutton
>
>
Received on Thu Feb 22 2001 - 11:42:16 CST