update UNIONMEMBERS
set UJOBID := '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID; update UNIONMEMBERS
set UJOBID = '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;
set UJOBID := '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID; update UNIONMEMBERS
set UJOBID = '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;
set UJOBID := '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;我已改成了
update UNIONMEMBERS
set UJOBID = '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;但还是出现相同的错误.
再帮我看看!!!!
DELETE or UPDATE OF UJOBID, UNIONID
ON UNIONSJOB
FOR EACH ROW
DECLARE I NUMBER;
BEGIN
if deleting then
select count(*) into i from unions where UNIONID = :old.UNIONID;
if i>0 then
update UNIONMEMBERS
set UJOBID = '' where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;
else
delete from UNIONMEMBERS where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;
end if;
else
update UNIONMEMBERS
set UNIONID=:new.UNIONID,UJOBID=:new.UJOBID
where UNIONID = :old.UNIONID and UJOBID = :old.UJOBID;
end if;
end;
/
select count(*) into i unions where UNIONID = :old.UNIONID