Chapter 42. PL/oraSQLSQL Procedural Language

Table of Contents

42.1. Overview
42.1.1. Advantages of Using PL/oraSQL
42.1.2. Supported Argument and Result Data Types
42.2. Structure of PL/oraSQL
42.2.1. Anonymous Block
42.2.2. Comments
42.3. Declarations
42.3.1. Declaring Function Parameters
42.3.2. Copying Types
42.3.3. Row Types
42.3.4. Record Types
42.4. Expressions
42.5. Basic Statements
42.5.1. Assignment
42.5.2. Executing a Query with a Single-Row Result
42.5.3. Executing Dynamic Commands
42.5.4. Doing Nothing At All
42.6. Control Structures
42.6.1. Returning from a Function
42.6.2. Returning from a Procedure
42.6.3. Calling a Procedure
42.6.4. Conditionals
42.6.5. Simple Loops
42.6.6. Looping through Query Results
42.6.7. Trapping Errors
42.7. Cursors
42.7.1. Implicit cursors
42.7.2. Explicit cursors
42.7.3. Processing Query Result Sets
42.7.4. Cursor Variables
42.8. Collections
42.8.1. Associative Arrays
42.8.2. Nested Tables
42.8.3. Collection Methods
42.9. Transaction Management
42.9.1. Operations Cursor With Transcations
42.10. Packages
42.10.1. Package Overview
42.10.2. Create Package
42.10.3. Create and Access Packages
42.10.4. Examples
42.10.5. Limitations
42.11. Table function
42.12. Error Handling
42.12.1. Overview of Exception Handling
42.12.2. Predefined Exceptions
42.12.3. Raising Exceptions Explicitly