GET IP and machine name of user....

Advertisement
hi friends,
i want to get IP address and machine name of the user who have access a form in web environment.
be4 when i was working in client/server invorement i was using the following
command
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS'),
SYS_CONTEXT('USERENV','HOST'),
SYS_CONTEXT('USERENV','OS_USER') from dual;
when i try to implement this command for my web form... it gets the information
(IP and machine name) of the server where applicaiton server resides and my application reside.
how the get the information of user's mahcine and IP in web environment?
please help!!!
regards, imran baig
Advertisement

Replay

hi again,
thanks for the help, but i am still in problem. i am using forms6i and 9iAS for deployment.
i tried to use d2kwutility and the code i used is:
DECLARE
OS_USER_NAME VARCHAR2(60);
MACH_NAME          VARCHAR2(100);
BEGIN
OS_USER_NAME := win_api_environment.get_windows_username(toBoolean('Y'));
MACH_NAME := WIN_API_ENVIRONMENT.Get_Computer_Name(toBoolean(MACH_NAME));
INSERT INTO COMMON.COM_USER_INFO VALUES(:GLOBAL.G_EMPLOYEE_ID,:GLOBAL.G_MODULE_ID,SYSDATE,
'SETUP > COMPANIES', 'F', :GLOBAL.G_USER_IP, MACH_NAME, OS_USER_NAME);
COMMIT;
CALL_FORM('COMPANIES_FRM',NO_HIDE,NO_REPLACE);
END;
:( BUT NO RESULTS..
library is attached but it doest work...
what to do now..
Please help its very urgent..
thanks, Imran Baig