Structure of procedures

The body of a procedure 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.

The SQL statements that can occur in procedures are described in “SQL statements allowed in procedures”.