Question

ORA-04098: 触发器 'SCOTT.TRIGGER_NEWACCOUNT' 无效且未通过重新验证

create trigger saynewaccount
after insert
on card
declare
begin
dbms_output.put_line('成功开户');
end;
/
在执行
insert into card(account,pwd,totulmoney) values('ccc',1234567,100);
Oracle显示ORA-04098: 触发器 'SCOTT.TRIGGER_NEWACCOUNT' 无效且未通过重新验证。

Answer 1

oracle中，不等于用 <>
所有 new，old的行级引用，应该加冒号

CREATE TRIGGER PROJ_CHANGE_PROJ_SETUPNO
BEFORE UPDATE OF PROJ_SETUPNO
ON BOCT_PROJECT
FOR EACH ROW
WHEN (:new.PROJ_SETUPNO<>:old.PROJ_SETUPNO)
BEGIN
SELECT BOCT_PROJ_CHANGE_ID.nextval INTO :new.PROJ_CHANGE_ID FROM dual;
INSERT INTO PROJ_CHANGE(
PROJ_ID,UPDATRTIME,ITEM,OLDVALUE,NEWVALUE
) VALUES (OLD.PROJ_ID,SYSDATE(),'立项编号',:OLD.PROJ_SETUPNO,:NEW.PROJ_SETUPNO
);

END PROJ_CHANGE_PROJ_SETUPNO;