10.3. Subprogram Encapsulation: Introduction to Packages

Packages provide a mechanism to logically group smaller program units together. The grouping of procedures into a package modularizes the code. Physically, the use of packages means fewer files and fewer modules to manage. Programmers are more inclined to reuse modular code.

Programmers who begin working on the system, built with packages, quickly grasp the overall architecture because they can learn the system in a top-down fashion—looking at whole modules and how they interface.

Figure 10-3 illustrates two procedures. To grant the use of these procedures to other applications requires a GRANT EXECUTE on each procedure. Imagine 50 procedures. Additional functionality means more procedures, ...

Get Programming Oracle® Triggers and Stored Procedures, Third 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.