While executing an PL/SQL script today on our Oracle 10g Database I was confronted with this error message:
Oracle Error: SP2-0027: Input is too long (> 2499 characters) - line ignored
I then looked up the line of code in the sql script and copied it over to Oracle Developer and run it. To my surprise the code went trough without any errors. Well, after surfing around and looking for a solution I found a Oracle Technote saying that there is a limitation within the sqlplus application with line length and alike.
After all, the solution to this is very simple. We just had to insert a line break in the long code and sqlplus was happy with it.
I wish all solutions were so simple 
If you enjoyed this post, make sure you subscribe to the RSS feed!
Yes that is very simple. But, how if I want to input sql statement more than 2499 character per line? can I modified any parameter in oracle? If it can. what parameter should i modified to?
I have problem with sql code which generate via EJB 3.0+Hibernate ORM. in my java code I write EJBQL statement that generated Hibernate OracleDialect which generate sql code more than 2499 character per line. (it’s not problem if I using DB2)
I don’t want to change my java code to solve this problem. any idea to solve it ?