oracle初学存储过程

先来一个错误的

create or replace procedure test_testisstr_sql varchar2(1500);begin---低压配电箱同步数据str_sql := 'create global temporary table table_test as select * from (select id_p                  from plpl t                minus                select id_p from ll)';                 execute immediate str_sql;              str_sql:='insert into llselect s.*  from plpl s where exists (select 1 from table_test t where t.id_p = s.id_p)';         execute immediate str_sql;str_sql:= 'drop table table_test';          execute immediate str_sql;         COMMIT;end;