Create two triggers in the same script.
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