[mojo-user] sql maven plugin problem

[Leonardo Ferrero]

Hi, i using sql-maven-plugin to create a Oracle Database. I've a problem
when try create triggers.
For exmple, when try create this simple trigger:

CREATE OR REPLACE TRIGGER pos2_development.insert_agents
 BEFORE
 INSERT
 ON pos2_development.agents
 REFERENCING OLD AS OLDREG NEW AS NEWREG
 FOR EACH ROW
BEGIN
  SELECT pos2_development.seq_agents.NEXTVAL INTO :NewReg.id  FROM DUAL;
END;

The plugin create that as following:
CREATE OR REPLACE TRIGGER pos2_development.insert_agents BEFORE INSERT ON
pos2_development.agents REFERENCING OLD AS OLDREG NEW AS NEWREG FOR EACH ROW
BEGIN SELECT pos2_development.seq_agents.NEXTVAL INTO :NewReg.id   FROM DUAL

And report this error:
PLS-00103: Has been the symbol "end-of-cases out" when one of the following
ones was expected:

   ;

Any idea?

Regards;

-- 
Leonardo Ferrero