The structure of procedures, triggers, and user-defined functions

The body of a procedure or trigger consists of a compound statement. A compound statement consists of a BEGIN and an END, enclosing a set of SQL statements. Semicolons delimit each statement.

 See also

Parameter declaration for procedures
Ways to pass parameters to procedures
Passing parameters to functions