Audiences for This Document

There are two primary developer audiences for this document:

• Developers experienced with Oracle Database and Oracle Database PL/SQL who want to learn how to use PL/SQL in TimesTen: These readers want to learn the differences between PL/SQL in Oracle Database and PL/SQL in TimesTen.

• Developers experienced with TimesTen who are not familiar with PL/SQL: These readers need general information about PL/SQL.

These audiences are discussed in the sections that follow:

• Developers Experienced with Oracle Database and Oracle Database PL/SQL

• Developers Experienced with TimesTen

Developers Experienced with Oracle Database and Oracle Database PL/SQL

Developers experienced with Oracle Database PL/SQL can bypass much of this document, which covers many general concepts of PL/SQL.

Likely areas of interest, particularly differences in PL/SQL functionality between Oracle Database and TimesTen, include the following. Note that TimesTen-specific considerations are discussed at the end of Programming Features in PL/SQL in TimesTen, Data Types in PL/SQL in TimesTen, and Errors and Exception Handling and throughout TimesTen PL/SQL Support: Reference Summary.

• Executing Procedures and Functions: This includes a comparison between how you can execute them in TimesTen and in Oracle Database.

• Differences in TimesTen: Transaction Behavior: This discusses cursor behavior when a transaction ends in TimesTen.

• Differences in TimesTen: Data Type Considerations: This includes TimesTen-specific conversions, and types that TimesTen does not support.

• Differences in TimesTen: Exception Handling and Error Behavior: This describes differences in error support, handling, and reporting.

• PL/SQL Environment: This includes discussion of TimesTen connection attributes.

• TimesTen Supplied PL/SQL Packages: This documents the subset of Oracle Database PL/SQL packages that TimesTen supports.

• TimesTen PL/SQL Support: Reference Summary: This reference chapter provides a detailed treatment of differences between TimesTen PL/SQL and Oracle Database PL/SQL.

Developers Experienced with TimesTen

Most of this document is targeted for readers without prior PL/SQL experience, especially prior TimesTen users who are not familiar with PL/SQL, and nearly the entire document should be useful.

In particular, Programming Features in PL/SQL in TimesTen, will help these readers get started and Examples Using TimesTen SQL in PL/SQL, includes some additional examples.

TimesTen PL/SQL Support: Reference Summary, lists differences between TimesTen PL/SQL and Oracle Database PL/SQL and may be of less interest.