Hints and tricks for Oracle and other stuff...

procedure ShowWebProperties(
  name_array  in owa.vc_arr,
  value_array in owa.vc_arr
  ) is
  v_baza varchar2(100);
  x varchar2(50);
begin
  select user'@'global_name into v_baza from global_name;
  htp.p('user@baza  = 'v_baza);
  htp.p('<hr>');
  for r in (select * from nls_session_parameters
            order by parameter)
  loop
    htp.p(r.parameter' = ' r.value'<br>');
  end loop;
  htp.p('<hr>');
  for r in (select * from nls_database_parameters
            order by parameter)
  loop
    htp.p(r.parameter' = ' r.value'<br>');
  end loop;
  htp.p('<hr>');
  owa_util.print_cgi_env;
  htp.p('<hr>');
end;