Create two triggers in the same script.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com>
Date: 2000/05/09
Message-ID: <39182304.7981390_at_news.alt.net>#1/1


How do I create two triggers in the same script.

Each of these works when run from SQL*Plus sepearately:

>>

CREATE OR REPLACE TRIGGER A_Trigger
BEFORE INSERT ON A_Table
FOR EACH ROW
BEGIN
        SELECT B_Sequence.NEXTVAL INTO :NEW.Id From Dual; END A_Trigger;

CREATE OR REPLACE TRIGGER B_Trigger
BEFORE INSERT ON B_Table
FOR EACH ROW
BEGIN
        SELECT B_Sequence.NEXTVAL INTO :NEW.Id From Dual; END B_Trigger;
<<

When run together, however, it says "Warning: Trigger created with compilation errors."

Looking at the trigger through Schema Manager I see The trigger Body of A_Trigger to be:
>>

BEGIN
        SELECT B_Sequence.NEXTVAL INTO :NEW.Id From Dual; END A_Trigger;

CREATE OR REPLACE TRIGGER B_Trigger
BEFORE INSERT ON B_Table
FOR EACH ROW
BEGIN
        SELECT B_Sequence.NEXTVAL INTO :NEW.Id From Dual; END B_Trigger;
<<

Am I issing a semi colon or something of the sort?

Brian Received on Tue May 09 2000 - 00:00:00 CEST

Original text of this message