OWA_UTIL.get_cgi_env returning incorrect values
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