[Error] "SP2-0341 Line Overflow" when deploying a script via SQLPlus

Applies to: 

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions:

• Using SQLPlus to deploy a changeset

Issue Summary:

When attempting to deploy a script via SQLPlus, an error will occur for a line overflow.

Error Message:

SP2-0341: line overflow during variable substitution (3000 characters at line 1)

Root Cause:

SQLPlus has a line limit of 3,000 characters after variable substitution. An SQL statement can exceed 3000 characters, but a single line inside the script file cannot. This has been fixed in newer versions of SQLPlus.

For example, the error will occur if line 2 below exceeds 3000 characters.

1 INSERT INTO (...)
2 VALUES (...); //exceeds 3000 characters

Resolution:

The line that exceeds 3000 characters needs to be broken up by a new line character.

1 INSERT INTO (...)
2 VALUES (...
3 ...);

Related Article(s):

SQL*Plus Limits