How to Redirect or Pass Thru (Hide) a Request With a Parameter Value : PL/SQL and Oracle Forms Example
(Doc ID 357384.1)
Last updated on MAY 30, 2023
Applies to:Oracle Forms - Version 10.1.2.0.2 and later
Oracle HTTP Server - Version 10.1.2.0.0 and later
Oracle Fusion Middleware - Version 10.1.2.0.0 and later
Information in this document applies to any platform.
Oracle Forms - Version: 10.1.2.0 to 10.1.2.3
How to Redirect a Request With a Parameter Value
This document provides a sample PL/SQL procedure to act as a test application to processes a parameter, and how to redirect the request based on a parameter value in the request string. There can be many configurations performed, for different functionality, but this document will show examples using this procedure and controlling its access on the server with mod_rewrite. This document steps through the following to set this up:
Create a working mod_plsql procedure that needs a parameter passed to it.
Optionally configure this longer address to be a "default page"
- Redirect a default mod_plsql DAD location to a longer URL which includes a parameter
- Designate a default mod_plsql DAD location to be associated to a longer URL, hiding the full URL from the browser address bar.
Based on the parameter value in the URL, redirect to a different location
- For specific parameter value(s), redirect to a URL to a single designated location
- For a specific parameter value, redirect only for desired client IP Addresses
Note: While a PL/SQL procedure is used for the example, the same can be applied to any application which accepts a parameter as part of a GET request, where the parameters is passed as part of the URL. Since a rewrite will take place before reaching the actual application, control of the request can be obtained beforehand, using Oracle HTTP Server functionality. For this case, skip to Step 3 to implement for your application.
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 Redirect a Request With a Parameter Value|
|Setting up a PL/SQL Application For Testing a Parameter and QUERY_STRING|
|Configuring Oracle HTTP Server to Rewrite on QUERY_STRING Condition|
|Different Tests to Perform Against the Sample|
|Example Using Oracle Forms|