Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E25519-05 |
|
|
PDF · Mobi · ePub |
A procedure is a subprogram that performs a specific action. A procedure invocation (or call) is a statement.
Before invoking a procedure, you must declare and define it. You can either declare it first (with procedure_declaration) and then define it later in the same block, subprogram, or package (with procedure_definition) or declare and define it at the same time (with procedure_definition).
A procedure declaration is also called a procedure specification or procedure spec.
Note:
This topic applies to nested procedures. For information about standalone procedures, see "CREATE PROCEDURE Statement". For information about package procedures, see "CREATE PACKAGE Statement".LNPLS1766Topics
LNPLS1278procedure_declaration ::=
LNPLS1279procedure_heading ::=
See "parameter_declaration ::=".
LNPLS1280procedure_definition ::=
See:
LNPLS1767procedure_declaration
Declares a procedure, but does not define it. The definition must appear later in the same block, subprogram, or package as the declaration.
LNPLS1768procedure_heading
LNPLS1769procedure
Name of the procedure that you are declaring or defining.
LNPLS1770procedure_definition
Either defines a procedure that was declared earlier or both declares and defines a procedure.
LNPLS1771declare_section
Declares items that are local to the procedure, can be referenced in body
, and cease to exist when the procedure completes execution.
LNPLS1772body
Required executable part and optional exception-handling part of the procedure.
LNPLS1773call_spec, EXTERNAL
See"call_spec" and "EXTERNAL".
LNPLS1774Restriction on call_spec, EXTERNAL These clauses can appear only in a package specification or package body.
LNPLS1775In this chapter:
LNPLS1776In other chapters: