JDBC data source initializer should be able to execute PL/SQL with embedded statements [SPR-7364]

[spring-projects-issues]

Dave Syer opened SPR-7364 and commented

JDBC data source initializer should be able to execute PL/SQL with embedded statements. This won't work, for instance:

create trigger item_trigger
before insert on item
for each row
begin
select item_seq.nextval into :new.id from dual;
end;
/

---

Referenced from: commits 14edc9f

[spring-projects-issues]

Dave Syer commented

Fixed (I hope). Added a "separator" property to the ResourecDatabasePopulator. To do PL/SQL you need to set it to "\n\n". The XML namespace also has a new <script ... separator="..."/> attribute.