Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Statement length exceeds

    i wrote a script to create a stored procedure :
    create procedure SP();
    ...
    end procedure;

    when i run the cript to create it i get the message "460 STATEMENT LENGTH EXCEEDS MAXIMUM".

    can sombody tell me what kind of error generate this message ?

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    The SPL routine is send to the dbserver as one big sql statement. You are hiting the limit of this (I thought it was 32 kb, but it could be bigger on newer versions??). Easiest solution, split your procedure into several smaller ones.

    Greetings,

    Rob Prop

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    thanks. i deleted spaces and comments and now it works fine.

Posting Permissions

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