problem in calling the procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problem in calling the procedure

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try to split the operation, or if you are just loading you can use the sqlloader....


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Posts
    211
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width