create or replace procedure test
as
begin
execute immediate 'create table table1 (a varchar2(10))';
execute immediate 'create table table2 (a varchar2(10))';
end test;
as
begin
execute immediate 'create table table1 (a varchar2(10))';
execute immediate 'create table table2 (a varchar2(10))';
end test;
也就是execute immediate 'ddl语句';begin
execute immediate 'create table table1 (a varchar2(10))';
execute immediate 'create table table2 (a varchar2(10))';
end;
才能执行create,drop,trucate等语句.