[Liquibase-user] New Topic: Issue with pl/sql package with sqlFile tag.

[Liquibase Community Forum]

A new topic, 'Issue with pl/sql package with sqlFile tag. ', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=740.new#new

The text of the topic is shown below:

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

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.