Oracle Trigger

[Pablo Szittyay]

I am testing DbUp and found that there is an error with some Oracle scripts for example a Trigger like this

CREATE OR REPLACE TRIGGER aa_1_ins

BEFORE INSERT ON aa_1 

FOR EACH ROW 

BEGIN 

SELECT aa_1_sequence.NEXTVAL INTO :NEW.ID FROM dual;

END;

is parsed into 2 scripts, because it is parsing until the semicolon, so the scripts runs with error the following script wich is invalid.

CREATE OR REPLACE TRIGGER aa_1_ins

BEFORE INSERT ON aa_1 

FOR EACH ROW 

BEGIN 

SELECT aa_1_sequence.NEXTVAL INTO :NEW.ID FROM dual