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 ?

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

thanks. i deleted spaces and comments and now it works fine.