declare i number(12); begin select seq_common_user.nextval into i from dual; insert into p_web_role(ROLE_ID,ROLE_NAME) values(i,'g03'); insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G',i); insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G01',i); insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G02',i); end;
begin transaction; 没有这样的语句
应该还有提交 declare i number(12); begin select seq_common_user.nextval into i from dual; insert into p_web_role(ROLE_ID,ROLE_NAME) values(i,'g03'); insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G',i); insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G01',i); insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G02',i); commit; end;
i number(12);
begin
select seq_common_user.nextval into i from dual;
insert into p_web_role(ROLE_ID,ROLE_NAME) values(i,'g03');
insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G',i);
insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G01',i);
insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G02',i);
end;
没有这样的语句
declare
i number(12);
begin
select seq_common_user.nextval into i from dual;
insert into p_web_role(ROLE_ID,ROLE_NAME) values(i,'g03');
insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G',i);
insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G01',i);
insert into p_web_prvl2role(inter_id,prvl_code,role_id) values(seq_common_user.nextval,'G02',i);
commit;
end;