Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Truncate statement within PL/SQL procedure won't compile!

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

From: Dave Sutton <dpsutton_at_marchsystems.co.uk>
Date: Wed, 21 Feb 2001 12:10:05 -0000
Message-ID: <970b4t$ej2$1@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 Wed Feb 21 2001 - 06:10:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US