| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Multiple triggers on same event
FWIR, it was allowed as far back as 7.3.4
Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Glenn.Travis@
sas.com To: ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_fatcity. Subject: Multiple triggers on same event
com
09/24/01
10:29 AM
Please
respond to
ORACLE-L
At what version did Oracle start allowing multiple triggers to be define on the same
event (insert)
for the same table?
I have several triggers defined on a table (before insert) which add a value
(:new.c1:=:new.c1+1) to
a field. These triggers are owned by several different users but all do the same
thing. When a row
is inserted, they ALL fire and the value (c1) is cumulatively incremented... Very
interesting.
Am I mistaken or was this not allowed prior to 8i? I always thought only one
trigger fired for
each event. But they all fired in 8.1.7.3. Also, any trigger owned by the owner of
the table
always fires last...
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: Glenn.Travis_at_sas.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Sep 24 2001 - 11:44:44 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: rthomas_at_hypercom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |