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”.

Procedures can contain control statements, which are described in “Control statements”.