这两个触发器无法再PL/SQL一次执行完毕,有什么办法可以解决这个问题吗?
CREATE OR Replace TRIGGER "tb_DeviceRegister_ID_TRIGGER" BEFORE
INSERT ON tb_DeviceRegister FOR EACH ROW
declare
next_checkup_no number;
begin
select DREG_SEQ.nextval
into next_checkup_no
from dual;
:NEW.ID := next_checkup_no;
end;
CREATE OR Replace TRIGGER "tb_VehicleTag_NID_TRIGGER" BEFORE
INSERT ON tb_VehicleTag FOR EACH ROW
declare
next_checkup_no number;
begin
select TAG_SEQ.nextval
into next_checkup_no
from dual;
:NEW.NID := next_checkup_no;
end;
CREATE OR Replace TRIGGER "tb_DeviceRegister_ID_TRIGGER" BEFORE
INSERT ON tb_DeviceRegister FOR EACH ROW
declare
next_checkup_no number;
begin
select DREG_SEQ.nextval
into next_checkup_no
from dual;
:NEW.ID := next_checkup_no;
end;
CREATE OR Replace TRIGGER "tb_VehicleTag_NID_TRIGGER" BEFORE
INSERT ON tb_VehicleTag FOR EACH ROW
declare
next_checkup_no number;
begin
select TAG_SEQ.nextval
into next_checkup_no
from dual;
:NEW.NID := next_checkup_no;
end;
BEFORE INSERT ON tb_DeviceRegister
FOR EACH ROW
DECLARE
next_checkup_no NUMBER;
BEGIN
SELECT DREG_SEQ.nextval INTO next_checkup_no FROM dual;
:NEW.ID := next_checkup_no;
END;
/CREATE OR REPLACE TRIGGER "tb_VehicleTag_NID_TRIGGER"
BEFORE INSERT ON tb_VehicleTag
FOR EACH ROW
DECLARE
next_checkup_no NUMBER;
BEGIN
SELECT TAG_SEQ.nextval INTO next_checkup_no FROM dual;
:NEW.NID := next_checkup_no;
END;
/这样在pl/sql developer命令窗口中执行是可以的
如果错误,贴出错误信息。