Truncate table in a procedure

[mooks]

Hi,

May I know if it is possible to use truncate table command in a procedure? I have tried it and it seems that I have encountering some error? can anyone help pls? Thanks! :)

[komes]

Hai....


We can give the truncate stmt with in pl/sql procedure.

using Execute immediate.
ex:
Execute Immediate (' Truncate table table_name');

i hope this will solve ur problem.


bye
komes