problem in calling the procedure

[manjunathk]

Hi friends,
I am trying to execute a procedure from sqlplus as follows:

declare
a icdr_pkg.icdr_type;
b temp_icdr_table%ROWTYPE;
begin
test_pr_icdr_proc(a,20010910000000,20010911000000,'8002219616,...................................... ....................8001234567')
end;

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

Thanks
manjunath

[sambavan]

Try to split the operation, or if you are just loading you can use the sqlloader....


Sam

[manjunathk]

Thanks Sam.
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.
Thanks
manjunath

[pando]

SP2-0027

this is a sql*plus error no? I mean as long as it is not some PL/SQL error your proc should work?