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!!