呵呵,ddl(truncate)语句是要动态执行的。
Create or Replace Procedure DS2002.p_gsmxb_copy
v_sqlstring varchar2(1024);
is
begin
insert into GSMXB_CB(select * from GSMXB_CB_LS);
commit;
insert into GSMXB_ZB(select * from GSMXB_ZB_LS);
commit;
v_sqlstring :='truncate table gsmxb_cb_ls reuse storage';
execute immediate v_sqlstring ;
--commit;ddl自动提交
v_sqlstring :='truncate table gsmxb_zb_ls reuse storage';
execute immediate v_sqlstring;
--commit;
end;
Create or Replace Procedure DS2002.p_gsmxb_copy
v_sqlstring varchar2(1024);
is
begin
insert into GSMXB_CB(select * from GSMXB_CB_LS);
commit;
insert into GSMXB_ZB(select * from GSMXB_ZB_LS);
commit;
v_sqlstring :='truncate table gsmxb_cb_ls reuse storage';
execute immediate v_sqlstring ;
--commit;ddl自动提交
v_sqlstring :='truncate table gsmxb_zb_ls reuse storage';
execute immediate v_sqlstring;
--commit;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货