Contents

Title and Copyright Information

1 mod_PL/SQL Overview

1.1 Database Access Descriptors

1.2 Processing client requests

1.3 Invoking mod_PL/SQL

1.3.1 POST and GET Methods

1.4 Overview of mod_PL/SQL Features

1.4.1 Authentication

1.4.1.1 Database Controlled Authentication

1.4.1.2 Deauthentication

1.4.1.3 Custom Authentication

1.4.1.3.1 Implementing the authorize function

1.4.2 Transaction model

1.4.3 Parameter passing

1.4.3.1 Overloaded parameters

1.4.3.2 Overloading and PL/SQL Arrays

1.4.3.3 Flexible Parameter Passing

1.4.3.4 Large parameters

1.4.4 File Upload and Download

1.4.4.1 Document Table Definition

1.4.4.1.1 Semantics of the CONTENT column

1.4.4.1.2 Semantics of the CONTENT_TYPE column

1.4.4.1.3 Semantics of the LAST_UPDATED column

1.4.4.1.4 Semantics of the DAD_CHARSET column

1.4.4.2 Old Style Document Table Definition

1.4.4.3 Relevant Parameters

1.4.4.3.1 document_table (Document Table Name)

1.4.4.4 document_path (Document Access Path)

1.4.4.4.1 document_proc (Document Access Procedure):

1.4.4.4.2 upload_as_[content_type]

1.4.4.5 File Upload

1.4.4.6 Specifying Attributes (Mime Types) of Uploaded Files

1.4.4.7 Uploading Multiple Files

1.4.4.8 File Download

1.5 CGI Environment Variables

1.5.1 NLS

1.5.1.1 REQUEST_CHARSET CGI environment variable

1.5.1.2 REQUEST_IANA_CHARSET CGI environment variable

2
Installing mod_PL/SQL

2.1 System Requirements

2.2 Before you begin

2.3 Installation

2.4 Installing required packages

2.5 Configuring the Oracle HTTP Server Listener

2.6 Accessing the mod_PL/SQL configuration page

2.6.1 pls.conf configuration file

2.7 Starting and stopping the Oracle HTTP Server Listener

3 Configuring mod_PL/SQL

3.1 mod_PL/SQL Settings

4 Setting up WebDB to run with
mod_PL/SQL

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.3 Conventions for Parameter Names in the Toolkit

5.4 HTML Tag attributes

5.5 mod_PL/SQL 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 mod_PL/SQLTutorial

6.1 Creating and Loading the Stored Procedure onto the Database

6.2 Creating an HTML Page to Invoke the Application