Published 20 November 2017
Entire procedure body not enclosed within BEGIN...END
It is a good practice to enclose the entire body of the routine within a BEGIN...END block.
The BEGIN … END block declaration is optional for stored procedures but it is mandatory for multi-line user-defined functions. To avoid confusion it is best to be consistent.