We are using liquibase against an Oracle database and we came accross a blocker.
We have some changesets using some PL/SQL blocks and we need to write the corresponding rollback scripts using PS/SQL blocks as well.
The problem is that liquibase does not handle the rollback tag as it handles the sql tag with PL/SQL.
When writing in the sql tag, we can specify the splitStatements property to false for PL/SQL blocks. We cannot do the same with the rollback tag, can we?
I think you can add <sql> blocks inside <rollback> so the best approach may be to expect the changeset to be written as