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.