SQLcl Liquibase verbose output

Josef3

Hi!

In the database installation via SQLcl we are just calling Liquibase command "lb update -changelog _install_packages.xml" and inside we have more than 300 <changeSet> with <sqlFile>. Each <changeSet> is one database package in separated file. 

Example snippet from _install_packages.xml:

.
.
.
 <changeSet author="test" id="sys_test_pkg.spc" runOnChange="true">
  <sqlFile dbms="oracle"
       path="sys_test_pkg.spc"
       splitStatements="false"
       relativeToChangelogFile="true"/>
 </changeSet>

 <changeSet author="test" id="sys_test_pkg.bdy" runOnChange="true">
  <sqlFile dbms="oracle"
       path="sys_test_pkg.bdy"
       splitStatements="false"
       relativeToChangelogFile="true"/>
 </changeSet>
.
.
.

During the installation, the content of each package is printed twice in the "ScriptRunner Executing:" and "Liquibase Executing:" sections in the output.

The example of the installation output:

SQL>
SQL>
SQL> liquibase update -changelog _install_packages.xml

ScriptRunner Executing: CREATE OR REPLACE PACKAGE SYS_TEST_PKG IS

PROCEDURE test_procedure_lb;

END SYS_TEST_PKG;
/
Liquibase Executed:CREATE OR REPLACE PACKAGE SYS_TEST_PKG IS

PROCEDURE test_procedure_lb;

END SYS_TEST_PKG;
/
ScriptRunner Executing: CREATE OR REPLACE PACKAGE BODY SYS_TEST_PKG IS

PROCEDURE test_procedure_lb IS
BEGIN
 NULL;
END test_procedure_lb;

END SYS_TEST_PKG;
/
Liquibase Executed:CREATE OR REPLACE PACKAGE BODY SYS_TEST_PKG IS

PROCEDURE test_procedure_lb IS
BEGIN
 NULL;
END test_procedure_lb;

END SYS_TEST_PKG;
/
######## ERROR SUMMARY ##################
Errors encountered:0

######## END ERROR SUMMARY ##################
SQL>
SQL>

Is there any way to modify the output generated by the "lb update" command to not be so verbose on the output and hide the content? There is a terrible flood on the output of all database packages and it is impossible to check visually anything inside.

Thanks in advance for your help!

Josef3

Hello everyone,

does anyone have any advice on this so verbose output and how to reduce it?

Thank you!