TOOL_ENV.GetvarSo in (client/server) forms 6i you could simply get the APPDATA folder via
Description Provides a way to import an environment variable into a VARCHAR variable.
Syntax PROCEDURE Tool_Env.Getvar (varname VARCHAR2, varvalue VARCHAR2);
Parameters varname The name of the environment variable.
varvalue The value of the environment variable.
** Retrieve the environment variable USER into a
** variable named :userid so you can use it in a
** connect string or other call.
in webforms this would give you the appdata folder on the application server; for forms 10g and above there is webutil for that; in lower versions you'd need to implement your own java bean in order to be able to get client environment variables.
user11141511 wrote:is a database procedure. tool_env is a forms package and thus not recognized by database PL/SQL. You need to declare your procedure in forms, not as a stored procedure.
1 create or replace procedure toolEnv_value is
2 tst varchar2(100);
3 tst2 varchar2(100);
SELECT SYS_CONTEXT ('USERENV', 'OS_USER') from dualwill give you the OS User running the application server in webforms, not the client OS user the same way as tool_env.getvar will give you environment variables from the application server.