Team,
Please ignore my above request, reached Oracle support and they confirmed it as a bug.
Here is the bug details and the workaround from Oracle support on this.
Its a bug and already tracked by SQLcl Development
Bug 34449082 : SECOND LB GENSCHEMA COMMAND IN SINGLE SQLCL SESSION BREAKS XML FILE & ADDS /
As a workaround do a genschema without -split.
Just verified the workaround and it works in the above case. Thanks.
a@PDB1> lb genschema -sql -label run3
--Starting Liquibase at 10:30:03 (version 4.9.1 #0 built at 2022-05-03 17:23+2221)
Export Flags Used:
Export Grants false
Export Synonyms false
[Method loadCaptureTable]:
[Type - TYPE_SPEC]: 163 ms
[Type - TYPE_BODY]: 56 ms
[Type - SEQUENCE]: 16 ms
[Type - DIRECTORY]: 11 ms
[Type - CLUSTER]: 19 ms
[Type - TABLE]: 380 ms
[Type - MATERIALIZED_VIEW_LOG]: 13 ms
[Type - MATERIALIZED_VIEW]: 6 ms
[Type - VIEW]: 13 ms
[Type - DIMENSION]: 14 ms
[Type - FUNCTION]: 19 ms
[Type - PROCEDURE]: 96 ms
[Type - PACKAGE_SPEC]: 28 ms
[Type - DB_LINK]: 11 ms
[Type - SYNONYM]: 23 ms
[Type - INDEX]: 24 ms
[Type - TRIGGER]: 14 ms
[Type - PACKAGE_BODY]: 35 ms
[Type - JOB]: 14 ms
[Method loadCaptureTable]: 955 ms
[Method processCaptureTable]: 449 ms
[Method sortCaptureTable]: 21 ms
[Method cleanupCaptureTable]: 6 ms
[Method writeChangeLogs]: 242 ms
a@PDB1>
b@PDB1> lb updatesql -changelog controller.xml -label run3
--Starting Liquibase at 10:30:15 (version 4.9.1 #0 built at 2022-05-03 17:23+2221)
-- Loaded 2 changeSets
-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: controller.xml
-- Ran at: 07/09/22, 10:30 am
-- Against: B@jdbc:oracle:thin:@pdb1
-- Liquibase version: 4.9.1
-- *********************************************************************
-- Lock Database
UPDATE B.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'rajeyaba-3WH3DK3 (192.168.0.113)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;
-- Changeset t1_table.xml::4361fb8b8b996a029b63ec0d36060914614fa62a::(A)-Generated
-- object is the same nothing to do;
-- Logging Oracle Liquibase extension actions to
DECLARE
id varchar2(200) := '4361fb8b8b996a029b63ec0d36060914614fa62a';
rawAction clob;
rawSxml clob;
myrow varchar2(2000);
action clob := '';
sxml clob := '';
dep varchar2(200) := '2526815837';
author varchar2(200) := '(A)-Generated';
filename varchar2(200) := 't1_table.xml';
insertlog varchar2(200) := 'insert into DATABASECHANGELOG_ACTIONS (id,author,filename,sql,sxml,deployment_id) values (:id,:author,:filename,:action,:sxml,:dep) returning rowid into :out';
updateaction varchar2(200) := 'update DATABASECHANGELOG_ACTIONS set sql = sql ||:action where rowid = :myrow ';
updatesxml varchar2(200) := 'update DATABASECHANGELOG_ACTIONS set sxml = sxml ||:sxml where rowid = :myrow ';
begin
action := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw(q'{LS0gb2JqZWN0IGlzIHRoZSBzYW1lIG5vdGhpbmcgdG8gZG8=}')));
sxml := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw(q'{CiAgPFRBQkxFIHhtbG5zPSJodHRwOi8veG1sbnMub3JhY2xlLmNvbS9rdSIgdmVyc2lvbj0iMS4wIj4KICAgPFNDSEVNQT5CPC9TQ0hFTUE+CiAgIDxOQU1FPlQxPC9OQU1FPgogICA8UkVMQVRJT05BTF9UQUJMRT4KICAgICAgPENPTF9MSVNUPgogICAgICAgICA8Q09MX0xJU1RfSVRFTT4KICAgICAgICAgICAgPE5BTUU+WDwvTkFNRT4KICAgICAgICAgICAgPERBVEFUWVBFPk5VTUJFUjwvREFUQVRZUEU+CiAgICAgICAgIDwvQ09MX0xJU1RfSVRFTT4KICAgICAgICAgPENPTF9MSVNUX0lURU0+CiAgICAgICAgICAgIDxOQU1FPlk8L05BTUU+CiAgICAgICAgICAgIDxEQVRBVFlQRT5EQVRFPC9EQVRBVFlQRT4KICAgICAgICAgPC9DT0xfTElTVF9JVEVNPgogICAgICA8L0NPTF9MSVNUPgogICAgICA8REVGQVVMVF9DT0xMQVRJT04+VVNJTkdfTkxTX0NPTVA8L0RFRkFVTFRfQ09MTEFUSU9OPgogICAgICA8UEhZU0lDQUxfUFJPUEVSVElFUz4KICAgICAgICAgPEhFQVBfVEFCTEU+CiAgICAgICAgICAgIDxTRUdNRU5UX0FUVFJJQlVURVM+CiAgICAgICAgICAgICAgIDxTRUdNRU5UX0NSRUFUSU9OX0RFRkVSUkVEPjwvU0VHTUVOVF9DUkVBVElPTl9ERUZFUlJFRD4KICAgICAgICAgICAgICAgPFBDVEZSRUU+MTA8L1BDVEZSRUU+CiAgICAgICAgICAgICAgIDxQQ1RVU0VEPjQwPC9QQ1RVU0VEPgogICAgICAgICAgICAgICA8SU5JVFJBTlM+MTwvSU5JVFJBTlM+CiAgICAgICAgICAgICAgIDxNQVhUUkFOUz4yNTU8L01BWFRSQU5TPgogICAgICAgICAgICAgICA8VEFCTEVTUEFDRT5VU0VSUzwvVEFCTEVTUEFDRT4KICAgICAgICAgICAgICAgPExPR0dJTkc+WTwvTE9HR0lORz4KICAgICAgICAgICAgPC9TRUdNRU5UX0FUVFJJQlVURVM+CiAgICAgICAgICAgIDxDT01QUkVTUz5OPC9DT01QUkVTUz4KICAgICAgICAgPC9IRUFQX1RBQkxFPgogICAgICA8L1BIWVNJQ0FMX1BST1BFUlRJRVM+CiAgIDwvUkVMQVRJT05BTF9UQUJMRT4KPC9UQUJMRT4=}')));
execute immediate insertlog using id,author,filename,action,sxml,dep returning into myrow;
end;
/ --;
INSERT INTO B.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('4361fb8b8b996a029b63ec0d36060914614fa62a', '(A)-Generated', 't1_table.xml', SYSTIMESTAMP, 3, '8:5f6f0119815fbe5ab672965b2275f383', 'createSxmlObject objectName=T1, ownerName=A', '', 'EXECUTED', NULL, 'run3', '4.9.1', '2526815837');
-- Changeset demo_call_procedure.xml::826bf00a97fe837fe3bf97e24e63bc524c89352f::(A)-Generated
CREATE OR REPLACE EDITIONABLE PROCEDURE "DEMO_CALL"
as
l_cnt number;
begin
select count(*) into l_cnt from t1;
dbms_output.put_line('I am the patched version got... '||l_cnt||' rows..');
end;
-- Logging Oracle Liquibase extension actions to
DECLARE
id varchar2(200) := '826bf00a97fe837fe3bf97e24e63bc524c89352f';
rawAction clob;
rawSxml clob;
myrow varchar2(2000);
action clob := '';
sxml clob := '';
dep varchar2(200) := '2526815837';
author varchar2(200) := '(A)-Generated';
filename varchar2(200) := 'demo_call_procedure.xml';
insertlog varchar2(200) := 'insert into DATABASECHANGELOG_ACTIONS (id,author,filename,sql,sxml,deployment_id) values (:id,:author,:filename,:action,:sxml,:dep) returning rowid into :out';
updateaction varchar2(200) := 'update DATABASECHANGELOG_ACTIONS set sql = sql ||:action where rowid = :myrow ';
updatesxml varchar2(200) := 'update DATABASECHANGELOG_ACTIONS set sxml = sxml ||:sxml where rowid = :myrow ';
begin
action := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw(q'{Q1JFQVRFIE9SIFJFUExBQ0UgRURJVElPTkFCTEUgUFJPQ0VEVVJFICJERU1PX0NBTEwiIAphcwpsX2NudCBudW1iZXI7CmJlZ2luIApzZWxlY3QgY291bnQoKikgaW50byBsX2NudCBmcm9tIHQxOwpkYm1zX291dHB1dC5wdXRfbGluZSgnSSBhbSB0aGUgcGF0Y2hlZCB2ZXJzaW9uIGdvdC4uLiAnfHxsX2NudHx8JyByb3dzLi4nKTsKZW5kOw==}')));
sxml := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw(q'{Q1JFQVRFIE9SIFJFUExBQ0UgRURJVElPTkFCTEUgUFJPQ0VEVVJFICJCIi4iREVNT19DQUxMIiAKYXMKbF9jbnQgbnVtYmVyOwpiZWdpbiAKc2VsZWN0IGNvdW50KCopIGludG8gbF9jbnQgZnJvbSB0MTsKZGJtc19vdXRwdXQucHV0X2xpbmUoJ1RhYmxlIHQyIGdvdCAnfHxsX2NudHx8JyByb3dzLi4nKTsKZW5kOw==}')));
execute immediate insertlog using id,author,filename,action,sxml,dep returning into myrow;
end;
/ --;
INSERT INTO B.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('826bf00a97fe837fe3bf97e24e63bc524c89352f', '(A)-Generated', 'demo_call_procedure.xml', SYSTIMESTAMP, 4, '8:5e0f57c43f459ff951fd6b340ad34f63', 'createOracleProcedure objectName=DEMO_CALL, ownerName=A', '', 'EXECUTED', NULL, 'run3', '4.9.1', '2526815837');
-- Release Database Lock
UPDATE B.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
b@PDB1>
b@PDB1> lb update -changelog controller.xml -label run3
--Starting Liquibase at 10:35:58 (version 4.9.1 #0 built at 2022-05-03 17:23+2221)
-- Loaded 2 changeSets
Running Changeset: t1_table.xml::4361fb8b8b996a029b63ec0d36060914614fa62a::(A)-Generated
Action logged sucessfully.
Running Changeset: demo_call_procedure.xml::826bf00a97fe837fe3bf97e24e63bc524c89352f::(A)-Generated
Procedure DEMO_CALL compiled
Action logged sucessfully.
No Errors Encountered
b@PDB1> exec demo_call;
I am the patched version got... 0 rows..
PL/SQL procedure successfully completed.
b@PDB1>