Table of Contents Previous Next


3 Stored Procedure Language

This chapter describes the Stored Procedure Language (SPL). SPL is a highly productive, procedural programming language for writing custom procedures, functions, triggers, and packages for Advanced Server that provides:
This chapter describes the basic elements of an SPL program, before providing an overview of the organization of an SPL program and how it is used to create a procedure or a function. Triggers, while still utilizing SPL, are sufficiently different to warrant a separate discussion (see Section 4 for information about triggers). Packages are discussed in the Database Compatibility for Oracle Developers Built-in Package Guide available at:
The remaining sections of this chapter delve into the details of the SPL language and provide examples of its application.

3 Stored Procedure Language

Table of Contents Previous Next