|Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)
Part Number E17126-03
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).
Note:This topic applies to nested procedures. For information about standalone stored procedures, see "CREATE PROCEDURE Statement". For information about package procedures, see "CREATE PACKAGE Statement".
Declares a procedure, but does not define it. The definition must appear later in the same block, subprogram, or package as the declaration.
The name that you give to the procedure that you are declaring or defining.
Either defines a procedure that was declared earlier or both declares and defines a procedure.
The optional declarative part of the procedure. Declarations are local to the procedure, can be referenced in
body, and cease to exist when the procedure completes execution.
The required executable part of the procedure and, optionally, the exception-handling part of the procedure.
Restriction on call_spec, EXTERNAL These clauses can appear only in a package specification or package body.
In this chapter:
In other chapters: