Naba,
I think you need something like this
CREATE OR REPLACE TRIGGER triggername
AFTER INSERT OR UPDATE OR DELETE
ON tablename
FOR EACH ROW
WHEN (NVL(new.fldname1,old.fldname1)is not null and
NVL(new.fldname2,old.fldname2)is not null)
DECLARE
BEGIN
processing goes here
END;
hth,
Chaim
Title: RE: Avoding Mutation of Table trigger
This can be simply solved by eliminating the WHEN condition on the
trigger and encapsulating that condition as part of a If .. THEN ... END IF
statement.
Raj
__
Rajendra
Jamadagni