Database Reference
In-Depth Information
8.2 PL/SQL Block Structure
The smallest meaningful grouping of code is known as a block. A block is a unit of code
that provides execution and scoping boundaries for variable declarations and exception
handling. PL/SQL allows us to create without name blocks and named blocks, which are
either procedures or functions. A PL/SQL block has up to four different sections.
Header
: Used only for named blocks. The header determines the way the named block or
program must be called. It is optional.
