Procedure Body

The procedure body starts with the START statement and ends with the END statement. This is also known as compound statement. Non-Atomic compound statement can be nested, but atomic compound statements can not be nested.

In the compound statement there’s first the declaration part, followed by the procedure logic. In the declaration part, please specify your declarations in the following order: variables, conditions, statements, cursors, and handlers.


   <declare variables>
   <declare conditions>
   <declare statements>
   <declare cursors>
   <declare handlers>