Nested compound statements in native SQL procedures

Nested compound statements are blocks of SQL statements that are contained by other blocks of SQL statements in native SQL procedures. Use nested compound statements to define condition handlers that execute more than one statement and to define different scopes for variables and condition handlers.

The following pseudo code shows a basic structure of an SQL procedure with nested compound statements:

CREATE PROCEDURE...
  OUTERMOST:  BEGIN
              ...
                INNER1:  BEGIN
                         ...
                           INNERMOST:  BEGIN
                                       ...
                                       ...
                                       END INNERMOST;
                         END INNER1;
                INNER2:  BEGIN
                         ...
                         ...
                         END INNER2;
             END OUTERMOST

In the preceding code, the OUTERMOST compound statement contains two nested compound statements: INNER1 and INNER2. INNER1 contains one nested compound statement: INNERMOST.