Sending Parameters as a GET or POST When Using mod_plsql (Doc ID 258285.1)

Last updated on APRIL 09, 2024

Applies to:

Goal

To state how to send and use the form data with mod_plsql when sent as a POST.
This is specific to any Oracle HTTP Server (OHS) version that supports use of 
mod_plsql to access the database, executing stored procedures on the web.

You can have a very basic HTML form, which passes at least one parameter and 
has a submit button. The Submit button calls either a POST or a GET method. A 
GET may work as expected, but a POST will have various results. You may also use
a GET by directly passing parameters in a URL.

The following was written for generic testing, but bottom of document
refers to an issue with 9iAS 1.0.2.2 to 9.0.2 migration. The POST and GET
tests described here are for any version, and mod_plsql was used as
an example application runtime to accept the parameters.

Solution