exception
when others then
dbms_output.put_line(sqlerrm);
--you can also insert the sqlerrm into your error_log_table
end your_trigger;
when others then
dbms_output.put_line(sqlerrm);
--you can also insert the sqlerrm into your error_log_table
end your_trigger;
ON FOXXZ1.EMPWD
FOR EACH ROW
BEGIN
update empwd set emp_nam=
(select foxmold.bsempms.emp_nam
from empwd,foxmold.bsempms
where foxmold.bsempms.emp_no=:new.emp_no
and empwd.emp_no=:new.emp_no)
where emp_no=:new.emp_no;
END;
• 读或修改触发语句的任何变异表,其中包括触发表本身。
• 读或修改触发表的约束表中的主关键字,唯一关键字和外部关键字列。除此之外的其他列
可以修改。解决方法是建两个触发器,一个语句级的一个行级的,在行级记录新旧值,在语句级进行修改
as
begin
update empwd set emp_nam=
(select foxmold.bsempms.emp_nam
from empwd,foxmold.bsempms
where foxmold.bsempms.emp_no=p_emp_no
and empwd.emp_no=p_emp_no)
where emp_no=p_emp_no;
end;
/
CREATE TRIGGER FOXXZ1.EMPWDTRIGGER1 AFTER INSERT
ON FOXXZ1.EMPWD
FOR EACH ROW
BEGIN
pro(:new.emp_no);
end;
/
SQL> CREATE OR REPLACE TRIGGER t_actorAffair_DOCISSUE_BIR_T BEFORE INSERT ON
t_actorAffair FOR EACH ROW
2 as
3 BEGIN
4 SELECT t_actorAffair_DOCISSUE_S.NEXTVAL INTO :NEW.ID FROM DUAL;
5 END;
6怎么不执行?怪