Applies to:
- Liquibase Pro
Conditions:
- Liquibase 3.10.0 or later
- Oracle Database
Question:
Can Liquibase fail when there are Oracle compilation errors, such as a syntax issue inside a CREATE PROCEDURE?
Answer:
Yes, this can be done using the Pro runWith command.
runWith allows Liquibase to deploy changesets via the native executor for a specific database. For Oracle, Liquibase can use SQL Plus to deploy changesets. There are additional attributes that can be set when using a native executor.
In the scenario of needing Liquibase to fail when there are Oracle changesets, sqlplus-sqlerror, can be set to WHENEVER SQLERROR EXIT FAILURE
.
Example
CLI
--sqlplus-sqlerror="WHENEVER SQLERROR EXIT FAILURE"
Liquibase Properties
liquibase.sqlplus.sqlerror="WHENEVER SQLERROR EXIT FAILURE"
Liquibase Environment variable
LIQUIBASE_SQLPLUS_SQLERROR="WHENEVER SQLERROR EXIT FAILURE"
Comments
0 comments
Article is closed for comments.