Oracle Application Express (MOSC)

MOSC Banner

OWA_UTIL.get_cgi_env returning incorrect values

edited May 24, 2018 10:30PM in Oracle Application Express (MOSC) 7 commentsAnswered

When building a URL to put into an email that an application generates, the following function was used:

function GetServerPortURL return varchar2 is     

  holdURL varchar2(500) := null;

begin

   

  holdURL := OWA_UTIL.get_cgi_env ('REQUEST_PROTOCOL') || '://' 

          || OWA_UTIL.get_cgi_env ('HTTP_HOST')      

          || OWA_UTIL.get_cgi_env ('SCRIPT_NAME') ||'/' ;

 

  return holdURL;

end;

This seemed to work fine since the application went production in 2013.  However, after upgrading the database from Oracle 11.2.0.4 to 12.1.0.2, it now returns these values:

http://dev.oraganization.com:4443/pls/apex/ in DEV

http://qual.oraganization.com:443/pls/apex/f in QUAL

http://prod.oraganization.com:443/pls/apex_p/f

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center