Need Client Info Like IP Address /OS Username

[ahmadbilal]

We are using Application Server For oracle Inhouse Developed System (Develpe In Forms 6i).We Need To Store The Client Information With Every Transaction Made On That Client Machine By The Respective User.I have Tried <font size="6"><font face="Verdana"><u><b>GetclientInfo.jar</b></u></font id="Verdana"></font id="size6">
i.e
User Open The Form Employee Detail By Using Internet Explorer.Enter Data In The Employee Form When Ever user Enter(Save) The data its IP Address Should Save In The Emp table.

[mirza_rehan]

You can use Sys_Context for this task


for OsUser

Sys_Context('UserEnv','OS_USer')

and for IP
Sys_Context('UserEnv','IP_ADDRESS')

hope it will solve yours problem


take care