I like the sqlFile refactoring. However, it doesn’t support “create or replace package” on Oracle. createProcedure does, but it doesn’t support referencing a file that holds the actual SQL like sqlFile does. Wouldn’t it by neat if we could?
This would make it easier to switch to Liquibase, as I’m doing now… I don’t want to let go of my clean SQL files. Somebody say Amen?
This worked out with the following:
foo.sql contains package code, starting with “create or replace package …”
Glad you figured it out.