Create two triggers in the same script.

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