My Oracle Support Banner

How to Configure Oracle HTTP Server MOD_PLSQL and Test a PLSQL Procedure (Doc ID 201319.1)

Last updated on MARCH 28, 2022

Applies to:

Oracle HTTP Server - Version to [Release AS10g to 12c]
Oracle Fusion Middleware - Version to [Release AS10g to 12c]
Information in this document applies to any platform.


The purpose of this document is to provide simple quick-start instructions on configuring Oracle HTTP Server to execute a simple stored "Hello World" PL/SQL procedure using mod_plsql.  This document outlines the simplest way to configure Oracle HTTP Server to run a simple PL/SQL procedure. From here, more custom procedures may be created, and Portal and/or APEX configurations may be used. Note there are different administration features available with different versions, but this document describes the underlying functionality in all mod_plsql versions.

Oracle HTTP Server 10g installed from the Companion CD (based on Apache 2.0) does not support MOD_PLSQL, referencing <Note: 428391.1>, "Is it Possible To Configure Mod_plsql With Apache 2.0?".  The Oracle HTTP Server shipped as part of Oracle Fusion Middleware 11g Web-Tier Utilities is based on Apache 2.2 and does support MOD_PLSQL. More information on this release is provided within <Note 1304604.1>, "Oracle Fusion Middleware 11g Web-Tier FAQ".



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 How to Configure Oracle HTTP Server MOD_PLSQL and Test a PL/SQL Procedure
 Oracle Database Schema and Package Setup
 Oracle HTTP Server / modplsql Configuration
 Testing Stored Procedures
 Logging Options for mod_plsql
 Troubleshooting / Debug
 Known Issues and Example Configurations
 Oracle Documentation for mod_plsql
 Version 12.1.3/12.1.2
 Version 11.1.1
 Version 10.1.3
 Version 10.1.2

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.