PL/SQL (MOSC)

MOSC Banner

Trigger only fires when changing the last one of the attributes listed in UPDATE OF

edited Sep 11, 2012 3:01AM in PL/SQL (MOSC) 12 commentsAnswered ✓
Hi all,

I have the following trigger definition:

CREATE OR REPLACE TRIGGER CX_TG_REQINV_GR_ATTR_RAU
   AFTER UPDATE OF STATE
   OR UPDATE OF KCS_CONSTRTYPE
   OR UPDATE OF CODE_CONSTR
   OR UPDATE OF PLACE
   OR UPDATE OF DESCRIPTION
   ON REQINV
   REFERENCING NEW AS NEW OLD AS OLD
   FOR EACH ROW
   .....

  Is there anything wrong with it? The problem is that the trigger does not fire unless I change the last of the attributes (DESCRIPTION).

If I exchange the last two lines, the trigger fires only when I change the PLACE attribute.

Maybe I miss something obvious, but the examples in the documentation have the same form.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center