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
1572
August 06, 2017 02:55AM
Re: Store Procedure and Input Parameters
127
August 06, 2017 08:11AM


Sorry, you can't reply to this topic. It has been closed.

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.