MySQL Forums
Forum List  »  Stored Procedures

Re: Store Procedure and Input Parameters
Posted by: Peter Brawley
Date: August 06, 2017 08:11AM

What was the error msg ?

END needs terminating semicolon. BEGIN/END need DELIMITER cmds surrounding the sproc, see the sproc manual page, but your sproc is just a single statement, so (i) lose BEGIN/END, then DELIMITER is not needed, but (ii) why bother with an sproc at all?



Edited 1 time(s). Last edit at 08/08/2017 11:25AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
175
August 06, 2017 02:55AM
Re: Store Procedure and Input Parameters
28
August 06, 2017 08:11AM


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.