一、通过存储过程
create or replace procedure test1111 is
begin
insert into tableA (col1,col2,col3) values ('a','a','a');commit;
insert into tableB(col1,col2,col3) values ('a','a','a');commit;
.........
end pro_test;