Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Truncate table inside a procedure?
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