December 2002
Intermediate to advanced
928 pages
85h 29m
English
Procedure or function that is defined in the declaration section of a PL/SQL block. The declaration of a local program must appear at the end of the declaration section, after the declarations of any types, records, cursors, variables, and exceptions. A program defined in a declaration section may be referenced only within that block’s executable and exception sections. It is not defined outside that block.
The following program defines a local procedure and a local function:
PROCEDURE track_revenue
IS
PROCEDURE calc_total (year_in IN INTEGER) IS
BEGIN
calculations here ...
END;
FUNCTION below_minimum (comp_id IN INTEGER)
RETURN BOOLEAN
IS
BEGIN
...
END;Local programs may be overloaded with the same restrictions as overloaded packaged programs.