Oracle® Web Application Programming for PL/SQL® Developers

Unit 16.4. Miscellaneous Utilities

Unit Objectives

After this unit, you will know how to:

• Return the Value of a CGI Environment Variable

• Return Names and Values of All CGI Environment Variables for a Particular PL/SQL Procedure

• Return the Full Virtual Path of the PL/SQL Agent that is Handling an HTTP Request

• Return the Name of a Procedure that is Being Invoked by the PL/SQL Gateway

• Return Information about the Calling PL/SQL Code Unit to the Called PL/SQL Code Unit

Return the Value of a CGI Environment Variable

The owa_util.get_cgi_env function returns the value of a specified CGI environment variable. If the variable is not defined, the function returns a NULL value. Although the WRB (Web Request Broker) is not operated through the CGI (Common ...