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 Transaction Mode

1.6 Parameter passing

1.6.1 Parameter Passing by Name (Overloaded parameters)

1.6.1.1 Overloading and PL/SQL Arrays

1.6.2 Flexible Parameter Passing

1.6.2.1 Two parameter interface

1.6.2.2 Four parameter interface

1.6.3 Large Parameter Passing

1.7 File Upload and Download

1.7.1 Document Table Definition

1.7.1.1 Semantics of the CONTENT column

1.7.1.2 Semantics of the CONTENT_TYPE column

1.7.1.3 Semantics of the LAST_UPDATED column

1.7.1.4 Semantics of the DAD_CHARSET column

1.7.2 Old Style Document Table Definition

1.7.3 Relevant Parameters

1.7.4 document_path (Document Access Path)

1.7.4.1 document_proc (Document Access Procedure):

1.7.4.2 upload_as_long_raw

1.7.5 File Upload

1.7.6 Specifying Attributes (Mime Types) of Uploaded Files

1.7.7 Uploading Multiple Files

1.7.8 File Download

1.8 Path Aliasing (Direct Access URLs)

1.9 Caching

1.9.1 Validation technique

1.9.2 Expires technique

1.9.3 The PL/SQL Gateway Cache

1.9.3.1 owa_cache package

1.9.3.2 Validation Model

1.9.3.3 Expires Model

1.9.4 System- and User-level Caching

1.10 Common Gateway Interface (CGI) Environment Variables

1.10.1 Overriding CGI Environment Variables

1.10.2 NLS

1.10.2.1 REQUEST_CHARSET CGI environment variable

1.10.2.2 REQUEST_IANA_CHARSE CGI environment variable

2 Securing applications through the PL/SQL Gateway

2.1 Authenticating Users

2.1.1 Basic (Database Controlled Authentication)

2.1.1.1 Deauthentication

2.1.2 Global OWA, Custom OWA, and Per Package (Custom Authentication)

2.1.3 REMOTE_USER CGI Environment Variable

2.2 Protecting the PL/SQL Procedures Granted to PUBLIC

2.3 Protecting the Administration pages

2.3.1 Protecting the Admin pages through Basic Authentication

2.3.2 Protecting the Admin pages through the Oracle Portal (Single Sign-On)

3 Installing the PL/SQL Gateway

3.1 System Requirements

3.2 Before you begin

3.3 Installation

3.4 Installing Required Packages

3.4.1 Installing PL/SQL Web Toolkit Packages

3.4.1.1 Upgrading from Oracle9i Application Server or WebDB Listener

3.4.1.2 Upgrading from OAS Installations to Oracle9i Application Server

3.5 Configuring the Oracle HTTP Server Listener

3.5.1 apachectl file

3.5.2 httpd.conf file

3.5.3 plsql.conf file

3.5.4 wdbsvr.app file

3.6 Accessing the PL/SQL Gateway Configuration page

3.6.1 plsql.conf configuration file

3.7 Starting and stopping the Oracle HTTP Server Listener

3.7.1 UNIX

3.7.2 Windows NT

4 Configuring the PL/SQL Gateway

4.1 Global Settings

4.1.1 Global Setting Accessible through the Configuration File

4.2 Database Access Descriptor settings

4.2.1 DAD Settings Accessible through the Configuration File

4.3 Cache settings

4.3.1 PL/SQL Caching

4.3.2 Session Cookie Caching

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 into the Database

6.2 Creating an HTML Page to Invoke the Application

A Setting up PL/SQL to run with WebDB

B Troubleshooting

OAS Compatibility

Using the mod_plsql without the /pls in the URL

Using Flexible Parameters and the Exclamation Mark

Logging

Controlling Database Processes for Each mod_plsql Request

Debugging

Error Code 503 (Service Temporarily Unavailable)

Index