View Single Post
  #9 (permalink)  
Old 09-01-10, 11:44
wilsonfv wilsonfv is offline
Registered User
 
Join Date: Apr 2009
Posts: 42
Code:
create procedure procedure_name()
language sql
begin

sql code1;

sql code2;

end@
First, add @ at the end of your procedure.
Second, you should see an input field right at the bottom of the command editor named "Statement termination character".
Means if you set @ as "Statement termination character", the editor once see the @, it will know this is the end of your procedure.
Reply With Quote