- Running DDL like truncate in procedure
1
2
3
4
5
create or replace procedure proc_truncate_table
is
begin
execute immediate 'truncate table data_table';
end;
- calling the above procedure
1
CALL proc_truncate_table ();
Oracle plsql DDL in procedure
This post is licensed under CC BY 4.0 by the author.