Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Code Block Components and Block Labels

A PL/SQL code block can consist of several section types and can contain nested code blocks. This section will discuss the various code block sections, nested code blocks, and the GOTO keyword.

Code Block Sections

There are four types of code block sections:

•Header	This is the optional first section of the code block. It is used to identify the type of code block and its name. The code block types are anonymous procedure, named procedure, and function. A header is used for only the latter two types.
•Declaration	This is an optional section of the code block. It contains the name of the local objects that will be used in the code block. These include variables, cursor definitions, and exceptions. This ...