Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get client machine name and IP address

JoshTheFlameJun 10 2007 — edited Apr 17 2008
Hi,
In my office I have one SERVER which has FORMS & Report Server installed and all the clients are accessing that application thru the following URL :

http://OraServer:8889/forms/frmservlet

to get the machine name I have read into a global variable like this

SELECT USERENV('TERMINAL' ) into :global.clientname FROM DUAL;

but obviously all the time its returning the SERVER machine name...not the name where client is accessing the program....so how can I get the client machine name..

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2008
Added on Jun 10 2007
10 comments
4,255 views