这样写:
CREATE TRIGGER "DBSNMP"."T_UPDATE_DM" AFTER
UPDATE OF "C_BZ", "C_BZDM", "C_MC", "N_BXH", "N_DM", "N_FDM", "N_XSSX",
"N_YX"
ON "user"."tabtest"
FOR EACH ROW update tabtest
set d_lasetedit = sysdate
where b_dm.n_bxh = :new.n_bxh
试试
CREATE TRIGGER "DBSNMP"."T_UPDATE_DM" AFTER
UPDATE OF "C_BZ", "C_BZDM", "C_MC", "N_BXH", "N_DM", "N_FDM", "N_XSSX",
"N_YX"
ON "user"."tabtest"
FOR EACH ROW update tabtest
set d_lasetedit = sysdate
where b_dm.n_bxh = :new.n_bxh
试试
UPDATE OF "C_BZ", "C_BZDM", "C_MC", "N_BXH", "N_DM", "N_FDM", "N_XSSX",
"N_YX"
ON "user"."tabtest"
for each row
begin
:new.d_lasetedit:= sysdate;
end;
/
begin
:new.d_lasetedit= :sysdate;
end;
后再续该数据时报错:
"触发器T_UPDATE_DM 无效且未通过重新验证"