CHAPTER 9Packages

Packages are the backbone of Oracle 11g application development. They let you group functions and procedures as components into libraries. Inside these package libraries you can have shared variables, types, and components. Components are functions and procedures. Unlike standalone stored functions and procedures covered in Chapter 6, stored packages divide their declaration from their implementation. Package specifications publish the declaration, and package bodies implement the declaration.

This chapter explains how to declare, implement, leverage, and manage stored packages. The sections are as follows:

Image Package architecture ...

Get Oracle Database 11g PL/SQL Programming 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.