Secure 5.2.1: SqlPlusSlashTerminatorCheck

SqlPlusSlashTerminatorCheck

Last updated: July 8, 2026

SqlPlusSlashTerminatorCheck is a built-in Liquibase policy check that detects slash terminator issues in changesets using runWith:sqlplus before deployment.

Uses

Use this check to detect missing or incorrect slash terminators in changesets that use runWith:sqlplus. It identifies PL/SQL constructs (including CREATE PROCEDURE, CREATE FUNCTION, CREATE TRIGGER, CREATE PACKAGE, CREATE TYPE, and anonymous BEGIN/DECLARE blocks) that are missing the required / terminator. It also detects DDL statements with both a ; and a / terminator. Without the /, SqlPlus hangs indefinitely. DDL statements with both a ; and a / execute twice, causing deployment failures. This check validates that the slash terminator is used correctly to avoid deployment failures. Like other policy checks, it can be configured with a severity level which returns an exit code designed to stop automated jobs.

This check reports issues; it does not modify your SQL or change how changesets run at deployment. At its default severity (INFO, exit code 0), it is informational and does not stop your pipeline. Raise the severity to enforce correctly terminated scripts as a pre-deployment quality gate. To control how Liquibase handles these issues when it executes changesets, see the --sqlplus-slash-terminator-validation parameter.

Liquibase version required	Liquibase 5.2.1+
Scope (--checks-scope)	changelog
Default status	enabled
Default severity (exit code)	0 ("INFO")
Customizable settings	No (static)

Before you begin

Your changelog includes changesets that use runWith:sqlplus. The check only evaluates those changesets.
You are connected to an Oracle database. This check only fires against Oracle.

Procedure

(Optional) View and customize the check

This check is enabled by default. To view its current configuration, run the following command:

liquibase checks show --check-name=SqlPlusSlashTerminatorCheck

+-----------------------------+---------------------+--------------------------------+---------------+---------+----------+-----------+------+
| Short Name                  | Category            | Description                    | Customization | Status  | Severity | Scope     | Type |
+-----------------------------+---------------------+--------------------------------+---------------+---------+----------+-----------+------+
| SqlPlusSlashTerminatorCheck | Scripting Standards | This check triggers when SQL   | <None>        | enabled | 0        | changelog | sql  |
|                             |                     | content has SqlPlus slash      |               |         |          |           |      |
|                             |                     | terminator issues that could   |               |         |          |           |      |
|                             |                     | cause hangs or double          |               |         |          |           |      |
|                             |                     | execution.                     |               |         |          |           |      |
+-----------------------------+---------------------+--------------------------------+---------------+---------+----------+-----------+------+
INFO: Customize 'checks show' table with --show-cols flag. Learn more with 'liquibase checks show --help'

Liquibase command 'checks show' was executed successfully.

To customize the severity of this check, run the following command:

liquibase checks customize --check-name=SqlPlusSlashTerminatorCheck

To run the check, use the checks run command.

liquibase checks run --check-name=<string>

stages:
  Default:
    actions:
      - type: liquibase
        command: checks run
        cmdArgs: {check-name: <string>}

liquibase checks run --check-name=<string>

stages:
  Default:
    actions:
      - type: liquibase
        command: checks run
        cmdArgs: {check-name: <string>}

Note: For flow files you'll need to run liquibase flow to apply your changes.

Example output

When a changeset uses runWith:sqlplus and is missing a slash terminator, liquibase validate --strict reports the issue:

Validate analysis has identified the following validation errors:

Changeset 'dev:add-update-salary-proc' at changelog.sql:4:
  - sqlContent: SqlPlus slash terminator issue detected in generated SQL:
Detected: CREATE stored object (PROCEDURE/FUNCTION/PACKAGE/TRIGGER)

Reason: SqlPlus requires '/' terminator after CREATE statements for stored objects

Solution: Add '/' on a new line after your PL/SQL block.
Example:
CREATE PROCEDURE my_proc AS
BEGIN
  NULL;
END;
/

Generated SQL:
CREATE OR REPLACE PROCEDURE update_salary(p_emp_id NUMBER, p_amount NUMBER) AS
BEGIN
    UPDATE employees SET salary = salary + p_amount WHERE employee_id = p_emp_id;
    COMMIT;
END;... [truncated]

Liquibase command 'validate' was executed successfully.