Contents

Title and Copyright Information

1 PL/SQL Gateway Overview

1.1 PL/SQL Gateway Configurations

1.2 Database Access Descriptors

1.3 Processing client requests

1.4 Invoking the PL/SQL Gateway

1.4.1 POST and GET Methods

1.5 Overview of PL/SQL Gateway Features

1.5.1 Authentication

1.5.1.1 Database Controlled Authentication (Basic Authentication Mode)

1.5.1.1.1 Deauthentication

1.5.1.2 Custom Authentication (Global OWA, Custom OWA, and Per Package Authentication Modes

1.5.1.2.1 Implementing the authorize function

1.5.2 Transaction model

1.5.3 Parameter passing

1.5.3.1 Overloaded parameters

1.5.3.2 Overloading and PL/SQL Arrays

1.5.3.3 Flexible Parameter Passing

1.5.3.4 Large parameters

1.5.4 File Upload and Download

1.5.4.1 Document Table Definition

1.5.4.1.1 Semantics of the CONTENT column

1.5.4.1.2 Semantics of the CONTENT_TYPE column

1.5.4.1.3 Semantics of the LAST_UPDATED column

1.5.4.1.4 Semantics of the DAD_CHARSET column

1.5.4.2 Old Style Document Table Definition

1.5.4.3 Relevant Parameters

1.5.4.3.1 document_table (Document Table Name)

1.5.4.4 document_path (Document Access Path)

1.5.4.4.1 document_proc (Document Access Procedure):

1.5.4.4.2 upload_as_long_raw

1.5.4.5 File Upload

1.5.4.6 Specifying Attributes (Mime Types) of Uploaded Files

1.5.4.7 Uploading Multiple Files

1.5.4.8 File Download

1.5.5 Path Aliasing

1.5.6 Caching

1.5.6.1 Overview

1.5.6.1.1 Validation technique

1.5.6.1.2 Expires technique

1.5.6.2 The PL/SQL Gateway cache

1.5.6.2.1 owa_cache package

1.5.6.2.2 Validation model

1.5.6.2.3 Expires model

1.5.6.3 System- and user-level caching

1.6 CGI Environment Variables

1.6.1 NLS

1.6.1.1 REQUEST_CHARSET CGI environment variable

1.6.1.2 REQUEST_IANA_CHARSET CGI environment variable

2
Installing the PL/SQL Gateway

2.1 System Requirements

2.2 Before you begin

2.3 Installation

2.4 Installing required packages

2.4.0.1 PL/SQL Web Toolkit Packages

2.4.0.1.1 Non-OAS Installations

2.4.0.1.2 OAS Installations

2.5 Configuring the Oracle HTTP Server Listener

2.5.1 apachectl file

2.5.2 httpd.conf

2.5.3 plsql.conf file

2.5.4 wdbsvr.app file

2.6 Accessing the PL/SQL Gateway configuration page

2.6.1 plsql.conf configuration file

2.7 Starting and stopping the Oracle HTTP Server Listener

3 Configuring the PL/SQL Gateway

3.1 Global Settings

3.2 Database Access Descriptor settings

3.3 Cache settings

3.3.1 PL/SQL Caching

3.3.2 Session Cookie Caching

4 Setting up WebDB to run with the PL/SQL Gateway

4.1 Before You Begin

5 Using the PL/SQL Web Toolkit

5.1 PL/SQL Web Toolkit Installation

5.2 Packages in the Toolkit

5.2.1 htp and htf packages

5.2.2 owa_image package

5.2.3 owa_opt_lock

5.2.4 owa_custom

5.2.5 owa_content

5.2.6 owa_cache

5.3 Conventions for parameter names in the toolkit

5.4 HTML tag attributes

5.5 PL/SQL Gateway and applets

5.6 Cookies

5.7 LONG Data Type

5.8 Extensions to the htp and htf Packages

5.9 String Matching and Manipulation

5.10 owa_pattern.match

5.11 owa_pattern.change

6 PL/SQL Gateway Tutorial

6.1 Creating and Loading the Stored Procedure onto the Database

6.2 Creating an HTML Page to Invoke the Application