Re: Overiding triggers!

From: Brendan Walsh <bwalsh_at_storm.ie>
Date: Wed, 24 Feb 1999 16:13:42 GMT
Message-ID: <36d423e8.23424783@firewall.storm.ie>

>Is it possible to stop a trigger from executing in certain situations.
>An example of why I would do this: An insert trigger assigns a sequence
>value to a field. However on some insert events I would like to assign a
>value from another source to this field.
>
>Thanks in advance
>
>George
>

You could only fire your trigger when your id field is null

e.g.

create trigger X_INS_TRG
before insert
on X
when ( new.id_field is null)
begin

        select X_SEQ.nextval into :new.id_field fom dual; end;

---

Brendan Walsh
Storm Technology Ltd.
bwalsh_at_storm.ie Received on Wed Feb 24 1999 - 10:13:42 CST