Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> insert/update triggers by same name....

insert/update triggers by same name....

From: <mberger_at_skypoint.com>
Date: 18 Oct 2004 11:07:39 -0700
Message-ID: <1098122859.656140.268960@f14g2000cwb.googlegroups.com>


Hello all,
I'm relatively new to Oracle, and came across a .sql script file to use to update a release for a product I support. It contains the following tr_supervisorupdate triggers, for insert AND for update. Does Oracle allow this ? It seems to me, this is an error on the part of the developers that supplied me with this script.

Thanks,
Mike

CREATE OR REPLACE TRIGGER tr_supervisorupdate AFTER INSERT ON PWSUPER FOR EACH ROW
DECLARE newSupID NUMBER;

BEGIN
blah-blah-blah
END tr_supervisorupdate;
/

CREATE OR REPLACE TRIGGER tr_supervisorupdate AFTER UPDATE ON PWSUPER FOR EACH ROW
DECLARE newSupID NUMBER;

BEGIN
blah-blah-blah
END tr_supervisorupdate; Received on Mon Oct 18 2004 - 13:07:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US