Chapter 16. Packages

Table of Contents

16.1. Introduction

16.2. Advantages

16.3. Package Components

16.3.1. Package Specification Syntax
16.3.2. Package Body Syntax

16.4. Creating Packages

16.4.1. Creating the Package Specification
16.4.2. Creating the Package Body

16.5. Referencing a Package

16.6. Using Packages With User Defined Types

16.7. Dropping A Package

16.1. Introduction

This chapter discusses the concept of packages in EnterpriseDB. Packages are the most important construct in SPL for building reusable code and employing object-oriented design techniques. A package is a collection of related database objects grouped together in the database. These database objects can include functions, stored procedures, cursors, variables and constants.