Multiple triggers on same event

From: Glenn Travis <Glenn.Travis_at_sas.com>
Date: Mon, 24 Sep 2001 09:23:57 -0700
Message-ID: <F001.003966B2.20010924092906@fatcity.com>

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...

Glenn Travis
glenn.travis_at_sas.com
Business Intelligence & Support
919-531-0434

--

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-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). Received on Mon Sep 24 2001 - 11:23:57 CDT