尝试从.sql脚本创建oracle包时Flyway解析器失败

Question

create or replace package <schema>.custom_package is 
  procedure getReleaseEmployees(p_Cursor in out sys_refcursor, p_Role in string); 
end custom_package;
/

create or replace package <schema>.pck_account_monitoring is
  procedure checkAndLockOracleAccount;
end pck_account_monitoring;
/
<...some more packages following>

SQL State  : 42000
Error Code : 900
Message    : ORA-00900: Invalid SQL Statement
Location   : migrations/sql/V0_2__migration.sql
Line       : 6172
Statement  : end pck_account_monitoring
    at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
    at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java:352)

create or replace package quattro.custom_package is procedure getReleaseEmployees(p_Cursor in out sys_refcursor, p_Role in string); end custom_package;
/
<rest as before>

Error Code : 900
Message    : ORA-00900: Invalid SQL Statement
...
Line       : 6167
Statement  : /

create or replace package quattro.pck_account_monitoring is ...

有没有人知道Flyway解析器出了什么问题，或者可以为我提供一个变通方法？

Answer 1

（这太长了，不适合发表评论，因此，我把它作为一个回答发布出来）

FWIW,我不能复制这个（使用Flyway 3.2.1命令行工具）；运行此示例脚本：

-- PACKAGES
create or replace package flyway_demo.custom_package is 
  procedure getReleaseEmployees(p_Cursor in out sys_refcursor, p_Role in string); 
end custom_package;
/

create or replace package flyway_demo.pck_account_monitoring is
  procedure checkAndLockOracleAccount;
end pck_account_monitoring;
/

create or replace package flyway_demo.logger
  authid definer
as
  -- TYPES
  type rec_param is record(
    name varchar2(255),
    val varchar2(4000));

  type tab_param is table of rec_param index by binary_integer;

  g_off constant number := 0;

  function is_number(p_str in varchar2)
      return boolean;
end logger;
/


create or replace package body flyway_demo.pck_account_monitoring is
  procedure checkAndLockOracleAccount is
  begin
    null;
  end;
end pck_account_monitoring;
/

create or replace package body flyway_demo.custom_package is 
  procedure getReleaseEmployees(p_Cursor in out sys_refcursor, p_Role in string)
  is
  begin
    open p_Cursor for select * from dual;
  end;
end custom_package;
/

create or replace package body flyway_demo.logger
as

  function is_number(p_str in varchar2) return boolean is
  begin
    return true;
  end;
end logger;
/

工作非常好。你能用这个脚本试一下，然后把你的发现贴出来吗？