pl/sql

[benjamenus]

An app changes the value of STATUS. If the status is changed to K, I wish to override it. I've tried putting the following into the after-update trigger

if :new.STATUS='K' then
:new.STATUS='X';
end if;

Obviously you cannot do this, but how can achieve the desired result?

 

[DaPi]

Try it as a BEFORE INSERT OR UPDATE trigger ..... think it should work. DaPi - no silver bullet

 

[AOLEURO]

....and the trigger must be a FOR EACH ROW like this:

create or replace trigger XXXXXXXXX
before insert or update on TABLENAME
for each row
BEGIN
IF :NEW.STATUS = 'K' THEN
:NEW.STATUS := 'X';
END IF;
END;


regards
Allan

 

[benjamenus]

Thought I'd tried that, but obviously not! Thank you.