- 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 ();
1
2
3
4
5
create or replace procedure proc_truncate_table
is
begin
execute immediate 'truncate table data_table';
end;
1
CALL proc_truncate_table ();