Forum Stats

  • 3,815,367 Users
  • 2,259,007 Discussions
  • 7,893,054 Comments

Discussions

SQLcl Liquibase verbose output

Josef3
Josef3 Member Posts: 9 Green Ribbon

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!

Comments