Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documents

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.2 Custom Authentication (Global OWA, Custom OWA, and Per Package Authentication Modes)

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.2 Old Style Document Table Definition

1.5.4.3 Relevant Parameters

1.5.4.4 document_path (Document Access Path)

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.2 The PL/SQL Gateway cache

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.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 Securing DAD Administration

3.4 Cache settings

3.4.1 PL/SQL Caching

3.4.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

Index