I am trying to execute a procedure from sqlplus as follows:
There are more than 400 numbers in between the ''.
I remember from earlier work that if the values between single quotes are having carriage returns then the results will be incorrect.But in my present execution I need to have these many numbers between the quotes and in a single line.
When I try executing that , the call fails saying that
"SP2-0027: Input is too long (> 2499 characters) - line ignored"
Is there a way out?(I am sure there will be as always but I am not able to get to it)
I am running 8.1.6 on compaq tru64 5.0a
Try to split the operation, or if you are just loading you can use the sqlloader....
Life is a journey, not a destination!
The procedure is not for inserting. It is a reporting procedure, and makes a join of 5 tables based on a where clause. The 800 numbers are part of the 'where' clause and I can split the operation when I am testing from sqlplus, but in real time it is going to be called from crystal reports, by many customers.
I may not have the choice to tell the users to reduce the numbers.
this is a sql*plus error no? I mean as long as it is not some PL/SQL error your proc should work?
Click Here to Expand Forum to Full Width