III. EnterpriseDB Superset Procedural Language

This chapter describes the EnterpriseDB Superset Procedural Language - SPL. SPL is a highly productive, procedural programming language for writing custom procedures, functions, and triggers for the EnterpriseDB database server.

SPL provides the following benefits:

Adds full procedural programming functionality to complement the SQL language
Provides a single, common language to create stored procedures, functions, and triggers for the EnterpriseDB database
Is integrated with Developer Studio to provide a seamless development and testing environment
Promotes the use of reusable code
Is easy to use

Table of Contents

14. Programming in SPL

14.1. Basic SPL Elements
14.2. SPL Programs
14.3. Variable Declarations
14.4. Basic Statements
14.5. Control Structures
14.6. Dynamic SQL
14.7. Static Cursors
14.8. REF CURSORS and Cursor Variables
14.9. Errors and Messages

15. Triggers

15.1. Overview
15.2. Types of Triggers
15.3. CREATE TRIGGER
15.4. Trigger Variables
15.5. Transactions and Exceptions
15.6. Trigger Examples

16. Packages

16.1. Introduction
16.2. Advantages
16.3. Package Components
16.4. Creating Packages
16.5. Referencing a Package
16.6. Using Packages With User Defined Types
16.7. Dropping A Package