Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2002
    Location
    New Jersey
    Posts
    7

    Unanswered: Query sizes and sybase 12

    Our Applicaton has a stored proc that is 17706 lines long. When I try to run this stored proc in sybase 12, it tells me that the procedure is corrupted and has to be recreated. The error also states that it was unable to build a query plan.

    Is anyone aware of any bug in sybase 12 . I have managed to work it around by splitting it into 3 pieces of code. This code was running on 11.9.2.



    Any help will be appreciated.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    If I recall correctly you should drop and recreate compiled/stored objects (stored procedures, triggers) upon upgrading.
    Thanks,

    Matt

  3. #3
    Join Date
    Mar 2002
    Location
    New Jersey
    Posts
    7
    Originally posted by MattR
    If I recall correctly you should drop and recreate compiled/stored objects (stored procedures, triggers) upon upgrading.

    Matt,

    I had recreated all stored procedures after the upgrade. But doesnot work.


    Thanks,
    Vijay

  4. #4
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    What is your exact version? Paste your SELECT @@version results please.
    Thanks,

    Matt

  5. #5
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya Vijay,

    The best option is to split the proc into smaller proc.

    What might be happening is with a stored proc being close to 12,000 lines the sysprocedures may be running out of sequence number. The datatype is smallint, which means the max number of lines for an object is 32,767.

    On ASE 12.5 the sequence column datatype is int, if you don't want to split the proc maybe go to 12.5

    Cheers
    Willy

Posting Permissions

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