Sorry, I should have mentioned that the app doesn't allow NULLs, even though
there's no constraint on that column. The column is type CHAR. The
:old.commodity_code check in the WHEN clause is there to account for
INSERTed rows. The table has about 200K rows total (inventory part master),
with on
Title: RE: Trigger fires when "WHEN" clause evals to false?
the trigger will fire if :new.commodity_code is null as well ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in
Since I'm getting nowhere fast with Oracle Support, I'll try this here:
While looking in V$DB_OBJECT_CACHE, we noticed an unpinned row-level trigger
had been fired over 900K times. We compared this to other row-level triggers
on the same table and noticed that the other triggers were only executed