A statement that can contain multiple SQL statements in an SQL
module procedure or in an embedded SQL procedure.
An embedded procedure that contains a compound statement is
called an embedded multistatement procedure. SQL supports a
restricted subset of SQL statements in a compound statement
embedded in a host langauge program. Refer to the Oracle Rdb
SQL Reference Manual for a list of valid SQL statements allowed
in a compound statement.
Compound statements can also include program-like, flow-
of-control statements (IF, LOOP, CASE, LEAVE), transaction
management statements (COMMIT and ROLLBACK), a variable
declaration statement (SET assignment), a cursor-processing
statement (FOR), and a procedure-debugging statement (TRACE).
See the Oracle Rdb SQL Reference Manual for a complete
description of a compound statement.