My Oracle Support Banner

SP2-00027: Input is too long (> 2499 characters) - line ignored (Doc ID 115005.1)

Last updated on FEBRUARY 19, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

You are trying to run a SQL query or script from an output file from a vendor 
package called SQLBacktrack.  The file has a SQL statement that is extremely 
long (in this case thousands of lines long and each row has thousands of 
characters) and you get the following error:

    SP2-0027: input is too long (> 2499 characters) - line ignored

This fails with the same error from either SQL*Plus or Server Manager.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.