--sqlplus-slash-terminator-validation
Last updated: July 8, 2026
Controls how Liquibase handles missing slash (/) terminators for runWith: sqlplus. PL/SQL blocks (such as CREATE PROCEDURE, FUNCTION, PACKAGE, TRIGGER, or anonymous blocks) require a / terminator. Without it, SQL*Plus can hang indefinitely, and statements that include both ; and / can run twice.
By default (FIX), Liquibase automatically corrects the issue at runtime and logs a warning: it appends the missing / terminator, or removes the extra ; from statements that contain both ; and /. The deployment continues and your script files are left unchanged.
Liquibase applies this setting at runtime, when it executes runWith: sqlplus changesets (for example, during an update). Set it as a global parameter; you do not pass it to a specific command.
Default: FIX
Note: This parameter applies to Oracle only.
To detect these issues before deployment, enable the SqlPlusSlashTerminatorCheck policy check.
Values
Value | Behavior |
| Automatically corrects the issue at runtime and logs a warning: appends a missing |
| Logs a warning about the slash terminator issue and continues without modifying anything. |
| Stops the deployment and throws an exception with a clear error message. |
Syntax
You can set this parameter in the following ways:
Option | Syntax |
Global CLI parameter |
|
Liquibase properties file (defaults file) |
|
Global flow file argument (example) |
|
JVM system property (JAVA_OPTS environment variable) |
|
Liquibase environment variable |
|