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.

Available in

SQL Prompt

SQL Code Guard