A PL/SQL package
A PL/SQL package encapsulates multiple PL/SQL constructs under a single unit. The PL/SQL constructs can be subprograms, cursors, variables, and exceptions. As a schema object, a PL/SQL package demonstrates the principles of logic hiding, encapsulation, and subprogram overloading.
Note
Standalone subprograms cannot be overloaded. Only packaged subprograms can be overloaded by their signatures.
The following diagram shows the advantages of a package:
A package has two components—the package specification and package body. While the package specification contains the prototype of public constructs, the package body contains the definition ...
Get Advanced Oracle PL/SQL Developer's Guide - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
