Re: question about triggers

Why do you use a after row trigger, you will never be able to modify a Table within a after row trigger, since it is mutating.

So use a before row triger and overwrite the value:

CREATE TRIGGER mytrigger
  BEFORE INSERT ON T1
  FOR EACH ROW
  WHEN ( new.a1 is NULL )
BEGIN
  a1 = 10;
END;
/

• Comment: do *not* forget the slash when entering a trigger within sqlplus, or another interactive shell.
• Comment: define a default for T1:

CREATE TABLE T1 (
  a1 number(6) DEFAULT 10,
   ...
);

Hope that helps.

Greetings Franz Received on Wed Oct 12 1994 - 15:52:52 CET