• Reference
  • Version · 6.0
  • Change Automation Reference

--sqlplus-slash-terminator-validation

Last updated: August 12, 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

FIX

Automatically corrects the issue at runtime and logs a warning: appends a missing / terminator, or removes the extra ; from statements that contain both ; and /. The deployment continues and your script files are not modified. (Default)

LOG

Logs a warning about the slash terminator issue and continues without modifying anything.

HALT

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

--sqlplus-slash-terminator-validation=<HALT|LOG|FIX>

Liquibase properties file (defaults file)

liquibase.sqlplus.slashTerminatorValidation: <HALT|LOG|FIX>

Global flow file argument (example)

globalArgs: { sqlplus-slash-terminator-validation: "<HALT|LOG|FIX>" }

JVM system property (JAVA_OPTS environment variable)

JAVA_OPTS=-Dliquibase.sqlplus.slashTerminatorValidation=<HALT|LOG|FIX>

Liquibase environment variable

LIQUIBASE_SQLPLUS_SLASH_TERMINATOR_VALIDATION=<HALT|LOG|FIX>

Previous--sqlplus-pathNext--sqlplus-sqlerror