Get User Information IP....

[misterimran]

hi,

i am using forms6i and 9iAS for deployment of forms.

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 VALUESGLOBAL.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.. how to get IP address and machine name of the user?? i have also tried..
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS'),
SYS_CONTEXT('USERENV','HOST'),
SYS_CONTEXT('USERENV','OS_USER') from dual;
but this show the IP and Machine name of the server where aplication resides and application server installed.

Please help its very urgent..
thanks, Imran Baig

 

[ikkyu65]

Some d2kwutil funtionality, you can get it, in 9iAS, with Webutil (look for webutil in OTN). Webutil is prepared to be run with Oracle 9i Forms version 9.0.2 and higher.
But it's possible to try it with Forms 6i, perhaps with some changes.

Webutil utility has a pll-library with a package named WebUtil_ClientInfo with the functions I think you need.

Best regards.

Enrique
-----------------------------------------------
These are the WebUtil Pre-Requisites:

In order to use WebUtil there are several version pre-requisites:
1. Forms Version - WebUtil is designed to be run with Oracle9i Forms version 9.0.2
and higher. No testing has been done with previous versions. Changes would be
required to the webutil.pll file if it is backported to Forms 6i.
2. Client Java Virtual Machine (JVM) – WebUtil requires either JInitiator 1.3.1.9 and
higher, or the Sun Java Plug-in Version 1.4.1.01 or higher. WebUtil uses certain
Java 1.3 features that are not available in earlier versions of the JVM.
3. Application Server Java Virtual Machine – For its Java operations on the middle
tier WebUtil needs a JVM of version 1.2.2 or higher. The JVMs supplied with
Oracle9iDS and Oracle9iAS are ideal.
4. Database Version – The file transfer facilities within WebUtil that post and get
files from the database need to be installed into a 9.0.1 database or higher. Using
WebUtil against an older database will mean that this type of file transfer is not
available to you.