SP2-0027: Input is too long (> 2499 characters) - line ignored
850822Jul 31 2012 — edited Aug 1 2012Hi all,
Oracle version :
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Calling a procedure to get the Dynamic sql query.
when i call the sql query in sqlplus like
spool c:\test.txt
sql query;
spool off
Error : facing the error "SP2-0027: Input is too long (> 2499 characters) - line ignored"
when i run the same query.in sql developer or plsql developer it is running fine.
thanks in advance