Add support for executing external scripts using @other_script.sql

[rehand]

As Flyway says, that is is compatible with all scripts which can be executed by SqlPlus ('Any Oracle sql script executed by Flyway, can be executed by SqlPlus [...]'), it would be nice to add support for executing other scripts within a script file like the following:

@other_script_1.fnc
@other_script_1.syn
@other_script_1.grt

Currently, Flyway interprets this as error:

ERROR: Error executing statement at line 1: @other_script_1.fnc
@other_script_1.syn
@other_script_1.grt

ERROR: Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement

ERROR: Occured in oracle.jdbc.driver.DatabaseError.throwSqlException() at line 112

Is there a way to add support for this? Otherwise I'd have to change all existing scripts in order to be able to use Flyway.

[axelfontaine]

Thanks for the report. I've documented it as a limitation. I have no immediate plans to fix this, as this has all kinds of hairy implications regarding loading and executing of these files (classpath, transactions, error handling, ...)

[cosmin]

+1 for finding a solution for this problem at some point. Loading the files from class path would work for my use case and I'm not clear what transaction or error handling limitations this would involve.

[KevinSheedy]

+1 I'm using Flyway for DDL but I still depend on SqlPlus for deploying procedures, functions from a single source of the truth in our git repo.
It'd be great if we could do it all with Flyway.

[adamlukaszewski]

+1 Would be greate to have this feature. We organize our sources (packages, table definitions, etc.) in different subfolders with (of course) git. With git and specific branches we ensure not to deploy sources in the wrong version. Nowadays we use a kind of install manifest (e.g. 1_5_5.sql) to reference this files. Actually the same way like flyway does it but not automated.

Cheers
Adam L.

[axelfontaine]

This should include support for both the @ and @@ (files only for now, no URLs) as well as the SET SUFFIX SQL*Plus commands.

To ensure parameters are processed correctly, #1883 should be implemented first.

Reference docs:

• @
• @@
• START
• SET SUFFIX

[axelfontaine]

This has now been implemented.