Monthly Archives July 2013

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

by Snehashish Ghosh

Scenario


 When we try to execute a script that has more than 2499 characters in it sqlplus throws an error

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

insert into t values(‘string that is more than 2499 character long in one line so that full coomand beginning from insert becomes more than 2500 characters’);

SQL> @c:\1.sql

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

SQL>

Solution


 This is a SQL*Plus limitation.

The sql command line length is limited to 2499 characters, this includes insert etc. commands and not only limited to string that may be more than 2500 character in length.

http://docs.oracle.com/cd/B19306_01/server.102/b14357/apa.htm#i635278%20

 sqlplus limitation

Method 1

To overcome this error SP2-0027: Input is too long (> 2499 characters) ...

Read More