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:

Goal

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:

Step 1:
Create a working mod_plsql procedure that needs a parameter passed to it.

Step 2:
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.

Step 3:
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.

Solution

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