MySQL Forums
Forum List  »  MySQL Workbench

Re: Every Attempt at Error Handling Fails with GET statement
Posted by: Peter Brawley
Date: December 03, 2019 10:56AM

SQL code and error messages are text; a pic would be a waste of time.

Did you follow my suggestion to try the code in the mysql client program?

As the manual page for Create Procedure says (and a commenter on that stackexchange page said too), creation of multi-statement routines needs DELIMITER management eg ...

delimiter go
Create Procedure ...
Begin
...
End;
go
delimiter ;

If that module in WB does not supply them, you need to.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.