Oracle in a Nutshell

Local Programs

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.