新手,刚弄了一个,有点疑惑,谢谢了
create or replace trigger UserToTemp after insert or update or delete
on BETRAYLIST for each row
declare
integrity_error exception;
errno integer;
errmsg char(200);
dummy integer;
found boolean;
begin
if inserting then
insert into FINISHREPORT(fID,NameBetray) values(fID=:NEW.fID,NameBetray=:NEW.NameBetray);
elsif updating then
update FINISHREPORT set NameBetray=:NEW.NameBetray where fID=:OLD.fID;
elsif deleting then
delete from FINISHREPORT where fID=:OLD.fID;
end if;
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;请看一下哪里出错了
create or replace trigger UserToTemp after insert or update or delete
on BETRAYLIST for each row
declare
integrity_error exception;
errno integer;
errmsg char(200);
dummy integer;
found boolean;
begin
if inserting then
insert into FINISHREPORT(fID,NameBetray) values(fID=:NEW.fID,NameBetray=:NEW.NameBetray);
elsif updating then
update FINISHREPORT set NameBetray=:NEW.NameBetray where fID=:OLD.fID;
elsif deleting then
delete from FINISHREPORT where fID=:OLD.fID;
end if;
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;请看一下哪里出错了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货