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

Home -> Community -> Usenet -> c.d.o.misc -> Truncate table inside a procedure?

Truncate table inside a procedure?

From: Steinar Orset <steinar_at_quasar.no>
Date: Fri, 30 Oct 1998 17:20:09 +0100
Message-ID: <3639E739.58C61893@quasar.no>


Hello,
Why can't I truncate a table inside a procedure? (However 'delete from temp' works, but it is said to be slower than truncate)

SQL> create or replace procedure cut_proc   2 is
  3 begin
  4 truncate table temp;
  5 end;
  6 /

Warning: Procedure created with compilation errors.

Regards Steinar Orset Received on Fri Oct 30 1998 - 10:20:09 CST

Original text of this message

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