A PL/SQL subprogram is a named PL/SQL block that can be invoked repeatedly. If the subprogram has parameters, their values can differ for each invocation.

A subprogram is either a procedure or a function. Typically, you use a procedure to perform an action and a function to compute and return a value.

• Reasons to Use Subprograms

• Nested, Package, and Standalone Subprograms

• Subprogram Invocations

• Subprogram Properties

• Subprogram Parts

• Forward Declaration

• Subprogram Parameters

• Subprogram Invocation Resolution

• Overloaded Subprograms

• Recursive Subprograms

• Subprogram Side Effects

• PL/SQL Function Result Cache

• PL/SQL Functions that SQL Statements Can Invoke

• Invoker's Rights and Definer's Rights (AUTHID Property)

• External Subprograms