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 JANUARY 17, 2017

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


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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms