LB 2.0.5 Pass variables to sqlFile script?

General Discussion
1

Hi all,

New to Liquibase and trying to use it to execute scripts in Oracle which have a &1 variable for the schema name.

We currently execute like “sqlplus user/pass@db @SCRIPT.sql TEST” where TEST will be the replacement for &1.  Is it possible to pass an argument similarly if Liquibase runs my script?

I looked at the parameter property option (e.g. -Dschema=TEST and ${schema} in the SQL script), but that prevents the SQL script from being executed outside Liquibase which is also a problem.

Appreciate any suggestions… Thanks!!