DBMS Output from Oracle DB

[Dennis]

Hello everyone,

I would like to know if there is any progress to this topic.
Here is a different Thread with the same question:

Get the dbms output from diferent DBMS with Liquibase

I have multiple databases from diferent DBMS (Oracle, SQLServer, DB2 and PostgreSQL) and my scripts are idempotent PL/SQL blocks. Here you can see an example. Oracle script: DECLARE TABLE NUMBER :=0; FIELD NUMBER :=0; BEGIN SELECT COUNT(*) INTO TABLE FROM USER_TABLES WHERE TABLE_NAME = 'TABLE_NAME'; IF TABLE>0 THEN SELECT COUNT(*) INTO FIELD FROM USER_TAB_COLS WHERE TABLE_NAME = 'TABLE_NAME' AND COLUMN_NAME = 'FIELD_NAME'; IF FIELD=0 THEN EXECUTE IMMEDIATE '…

Thanks!

[daryldoak]

It’s not possible to display output from stored procedures into the Liquibase output with Liquibase Community, but you can use runWith:sqlplus if you have PRO. If not, I’d suggest writing messages to a database table.

Use SQL Plus and runWith on Oracle

[PJatLiquibase]

Also, depending on your use case @Dennis, you might be able to accomplish your goal by using preconditions. See Preconditions