Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documentation

Documentation Accessibility

Conventions

Oracle Services and Support

1 Understanding mod_plsql

1.1 Processing Client Requests

1.2 Database Access Descriptors (DADs)

1.3 Invoking mod_plsql

1.4 Transaction Mode

1.5 Supported Data Types

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 Configuration Parameters for Document Upload/Downloading

1.7.3.1 PlsqlDocumentTablename

1.7.3.2 PlsqlDocumentPath (Document Access Path)

1.7.3.3 PlsqlDocumentProcedure (Document Access Procedure)

1.7.3.4 PlsqlUploadAsLongRaw

1.7.4 File Upload

1.7.5 Specifying Attributes (Mime Types) of Uploaded Files

1.7.6 Uploading Multiple Files

1.7.7 File Download

1.7.8 Direct BLOB Download

1.8 Path Aliasing (Direct Access URLs)

1.9 Common Gateway Interface (CGI) Environment Variables

1.9.1 Adding and Overiding CGI Environment Variables

1.9.2 PlsqlNLSLanguage

1.9.2.1 REQUEST_CHARSET CGI Environment Variable

1.9.2.2 REQUEST_IANA_CHARSET CGI Environment Variable

1.10 Restrictions in mod_plsql

2 Using mod_plsql

2.1 Before You Begin

2.2 Installing Required Packages

2.2.1 Upgrading from Oracle Application Server or WebDB Listener

2.3 Accessing the mod_plsql Configuration Page

2.3.1 Access the DAD Configuration Pages Through Oracle Enterprise Manager

2.3.2 Access the DAD Configuration Pages Through Portal

2.4 Configuring mod_plsql for Use with OracleAS Portal 3.0.9

3 Securing Application Database Access Through mod_plsql

3.1 Authenticating Users Through mod_plsql

3.1.1 Basic (Database Controlled Authentication)

3.1.2 Oracle Application Server Basic Authentication Mode

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

3.2 Deauthenticating Users

3.3 Protecting the PL/SQL Procedures Granted to PUBLIC

3.3.1 Using the PlsqlExclusionList Directive in mod_plsql

3.3.2 Accessing the PlsqlExclusionList Directive

A Frequently Asked Questions

Index