ApEx, Oracle, PL/SQL

Getting Session Environment Parameters in Oracle

To display all environment variable values for a given oracle session, run the following code: begin FOR i IN 1..owa.num_cgi_vars LOOP htp.p(owa.cgi_var_name(i)||’ : ‘||owa.cgi_var_val(i)); END LOOP; end; The name of the environment variable and value will be displayed. To reference each variable individually use the following syntax: OWA_UTIL.get_cgi_env(VARIABLE_NAME) eg. OWA_UTIL.get_cgi_env(‘REQUEST_PROTOCOL’) […]