Issue with pl/sql package with sqlFile tag.

General Discussion
1

Hi,

I’m having an issue when running PL/SQL packages with the sqlFile tag.

CREATE OR REPLACE PACKAGE BODY BLA_BLA_BLA AS

PROCEDURE LOOKUP_PROCEDURE(IO_error_msg    IN OUT  ERRORS.TEXT%TYPE,
                                                  IO_ITM  IN OUT  ITEM_TBL) IS
L_program      VARCHAR2(50) := ‘LOOKUP_P.LOOKUP_FUNCTION’;
L_supplier SUPS.CONTACT_TELEX%TYPE;

after this cursors etc is defined and then begin end block etc. But the only thing that liqiubases is able to enter is until:

L_program      VARCHAR2(50) := ‘LOOKUP_P.LOOKUP_FUNCTION’;

Everything after this line is missing after liquibase has processed the package. I have not ended the package body with / end; is the last line. Any idea what I need to do to get liquibase to process this, when run from sqldeveloper the body processes fine.

Thanks for great software,
Gustav

2

I’m using 2.0 rc5.
//Gustav

3

Sorry I had forgot the splitSql=false flag. That was the issue :slight_smile:

//Gustav

4

Glad you found it.  Thanks for the update

Nathan