Table of Contents
- Title and Copyright Information
- About This Content
- What's New
- 1 Introduction to PL/SQL in TimesTen
-
2
Programming Features in PL/SQL in TimesTen
- 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
- 3 Data Types in PL/SQL in TimesTen
- 4 Errors and Exception Handling
-
5
Examples Using TimesTen SQL in PL/SQL
- Examples Using the SELECT...INTO Statement in PL/SQL
- Example Using the INSERT Statement
- Examples Using Input and Output Parameters and Bind Variables
- Examples Using Cursors
- Examples Using FORALL and BULK COLLECT
- Examples Using EXECUTE IMMEDIATE
- Examples Using RETURNING INTO
- Example Querying a System View
- 6 PL/SQL Environment
- 7 TimesTen Supplied PL/SQL Packages
- 8 TimesTen PL/SQL Support: Reference Summary