Re: Store Procedure and Input Parameters
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.
Subject
Views
Written By
Posted
4206
August 06, 2017 02:55AM
Re: Store Procedure and Input Parameters
587
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.