Does Flyway support executing multiple SQL scripts called from one SQL script?

Question

I am trying to execute multiple scripts from one SQL file, running it in sequence. E.g. if I have V1.0__Test0.sql, and the contents are:

@V1.1__Test1.sql;
@V1.1__Test2.sql;

If I run the migrate option, I get an ORA-00900: invalid SQL statement error. Does Flyway support what I am trying to achieve?

The @ is a SQL*Plus command not a standard SQL statement. So that can't be used through JDBC (or any other tool that is not SQL*Plus) — user330315
– user330315, Commented Oct 30, 2015 at 12:21

Axel Fontaine · Accepted Answer · 2015-10-30 12:29:53Z

2

answered Oct 30, 2015 at 12:29

Axel Fontaine

35.4k19 gold badges110 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thank you,Axel. Would there be a workaround to achieve what I want to though?

looks like it does now, there are clearly many examples doing multiple statements in one migration file flywaydb.org/documentation/concepts/…