A
alei_nb
Unregistered / Unconfirmed
GUEST, unregistred user!
有什么错误吗？？？？为什么在插入时候说触发器无效
CREATE TRIGGER TDCFS.INSERTLIGHTER_CTN_INFO AFTER INSERT
ON TDCFS.LIGHTER_CTN_INFO
FOR EACH ROW
DECLARE
ABC Number;
BEGIN
SELECT COUNT(*) INTO ABC FROM T_MAIN WHERE PRIMARY_KEY=:NEW.LIGHTERID AND WORK_TYPE='C';
IF ABC=0 THEN
insert into t_main(primary_key,work_type,SMS_SEQ,FAX_SEQ,EMAIL_SEQ) values
new.lighterid,'C',0,0,0);
end if
end;
CREATE TRIGGER TDCFS.INSERTLIGHTER_CTN_INFO AFTER INSERT
ON TDCFS.LIGHTER_CTN_INFO
FOR EACH ROW
DECLARE
ABC Number;
BEGIN
SELECT COUNT(*) INTO ABC FROM T_MAIN WHERE PRIMARY_KEY=:NEW.LIGHTERID AND WORK_TYPE='C';
IF ABC=0 THEN
insert into t_main(primary_key,work_type,SMS_SEQ,FAX_SEQ,EMAIL_SEQ) values
new.lighterid,'C',0,0,0);end if
end;