My Oracle Support Banner

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 and later
Oracle HTTP Server - Version and later
Oracle Fusion Middleware - Version and later
Information in this document applies to any platform.
Oracle Forms - Version: to


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.


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

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