2 Programming Features in PL/SQL in TimesTen

This chapter surveys the main PL/SQL programming features providing examples.

See Overview of PL/SQL in Oracle Database PL/SQL Language Reference. Unless otherwise noted, the examples have the same results in TimesTen as in Oracle Database.

See the end of the chapter for TimesTen-specific considerations. See TimesTen PL/SQL Components and Operations for an overview of how applications interact with TimesTen in general and PL/SQL in particular.

The following are the main topics of this chapter:

• PL/SQL Blocks

• PL/SQL Variables and Constants

• SQL Function Calls from PL/SQL

• PL/SQL Control Structures

• PL/SQL Procedures and Functions

• PL/SQL Packages

• How to Pass Data Between an Application and PL/SQL

• Use of SQL in PL/SQL Programs

• TimesTen PL/SQL with Cache

• Use of Cursors in PL/SQL Programs

• Wrapping PL/SQL Source Code

• Differences in TimesTen: Transaction Behavior

Note:

Except where stated otherwise, the examples in this guide use the TimesTen ttIsql utility (which has the Command> prompt). In order to display output in the examples, the setting SET SERVEROUTPUT ON is used. See ttIsql in Oracle TimesTen In-Memory Database Reference.