oracle触发器无效且未通过重新验证
触发器代码如下:
CREATE OR REPLACE
TRIGGER WcmToItpUser
AFTER INSERT OR UPDATE OR DELETE ON wcmuser
FOR EACH ROW
BEGIN
case
when inserting then
insert into dzitp.itp_systemuser(USERID,ADDRESS,CRTIME,CRUSER,EMAIL,FAILDATE,ISDELETED,loginFails,LOGINIP,LOGINTIME,LOGINTIMES,PASSWORD,STATUS,TELPHONE,TRUENAME,USERTYPE,USERNAME)
values(:new.id,:new.ADDRESS,to_date(:new.CRTIME,'yyyy-mm-dd HH:mm:ss'),'wcm',:new.EMAIL,to_date(:new.CRTIME,'yyyy-mm-dd'),'1','0','127.0.0.1',to_date(:new.CRTIME,'yyyy-mm-dd HH:mm:ss'),'0','1822235B61622C4B4B6F5D28605A3334','1',:new.tel,:new.nickname,'1',:new.username);
when updating then
update dzitp.itp_systemuser set TRUENAME=:new.nickname,ADDRESS=:new.ADDRESS where USERID=:new.id;
when deleting then
delete dzitp.itp_systemuser where username=:old.username;
end case;
END;
第一次接触触发器,请大神指点。