Forum Stats

  • 3,815,372 Users
  • 2,259,010 Discussions
  • 7,893,059 Comments

Discussions

lb upload of stored procedure is merging last 2 lines

vmuthadi
vmuthadi Member Posts: 8 Red Ribbon
edited Mar 10, 2022 10:47AM in SQLcl

Hi,

I am trying to upload object type procedure from one instance to other instance using sqlcl lb command. But noticed that during upload liquibase is merging last 2 lines into 1 single line and hence causing package to be invalidaing. Below are the details of the same.

Extracted code as below

$ lb genobject -type procedure -name TEST_PROCEDURE

Action successfully completed please review created file test_procedure_procedure1.xml

Below is the last 5 lines of code from xml file

apex_mail.push_queue;

-- This is test;


END test_procedure;

]]></n0:source>

        </n0:createOracleProcedure>

    </changeSet>

</databaseChangeLog>

Then tried importing to target as below

$ lb update -changelog test_procedure_procedure1.xml

ScriptRunner Executing: test_run_email_send_procedure1.xml::49a3c32e5cd606ce42cefbe3c46a6d8009e5866c::(WATS_PROD)-Generated

 -- DONE

######## ERROR SUMMARY ##################

Errors encountered:0


######## END ERROR SUMMARY ##################


Execution is successful as per lb command but my object became invalid, When i checked the procedure DDL in DB below are last lines.

apex_mail.push_queue;

-- This is test;END test_procedure;

I am using sqlcl version 21.4 and this is against XE Database. request your assistance on what is missing over here.

PS: Itried a workaround like adding spaces, new lines, etc., in source instance and issue is always same.