[Squirrel-sql-users] Creating Triggers in Oracle 10g

[Will H. <wil...@co...>]

Following ddl:

CREATE OR REPLACE TRIGGER PAPCAT.TR_S_12796_1_PROCUREMENT_PLAN
 BEFORE INSERT ON PAPCAT.PROCUREMENT_PLANNING_REPORT
 FOR EACH ROW
BEGIN
 SELECT PAPCAT.S_12796_1_Procurement_Plan.nextval
 INTO :new.ID
 FROM dual;
 END;

should create the trigger:

BEGIN
 SELECT PAPCAT.S_12796_1_Procurement_Plan.nextval
 INTO :new.ID
 FROM dual;
 END;

Instead, it somehow hangs on the first semicolon and the (invalid) trigger
is created as:

BEGIN
 SELECT PAPCAT.S_12796_1_Procurement_Plan.nextval
 INTO :new.ID
 FROM dual


Note that the semi-colon after dual as well as END; is missing.

Any way I can get the entire trigger to be submitted as a unit?