Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

850822Jul 31 2012 — edited Aug 1 2012
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2012
Added on Jul 31 2012
16 comments
35,860 views