The structure of procedures and triggers

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


Declaring parameters for procedures
Passing parameters to procedures
Passing parameters to functions