O'Reilly logo

Oracle Database 11g PL/SQL Programming by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required