OraFAQ Forum: Forms » How to determine client IP address?

Home » Developer & Programmer » Forms » How to determine client IP address?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to determine client IP address? [message #155980]

Fri, 20 January 2006 02:18

naeemjeewani
Messages: 3
Registered: January 2006

Junior Member

hi!!

how to determine the IP address of the client in oracle forms?

i've tried SYS_CONTEXT('USERENV','IP_ADDRESS') but when i compile the form it says identifier SYS_CONTEXT must be declared.
plz help!!

[Updated on: Fri, 20 January 2006 02:33]

Report message to a moderator

Re: How to determine client IP address? [message #155984 is a reply to message #155980]

Fri, 20 January 2006 02:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

SYS_CONTEXT is not available in client side PL/SQL. I believe a Java Bean is needed for the Web-based Forms (check out the forms demos at http://otn.oracle.com/sample_code/products/forms/index.html). I believe the one you need is 'Get Client Info'. If you would try SYS_CONTEXT from the server side, you'd get the application server's IP.

MHE

Report message to a moderator

Re: How to determine client IP address? [message #156011 is a reply to message #155984]

Fri, 20 January 2006 04:19

naeemjeewani
Messages: 3
Registered: January 2006

Junior Member

yea but i m building a desktop application. i dont need web forms related functions or utils.

Report message to a moderator

Re: How to determine client IP address? [message #156017 is a reply to message #156011]

Fri, 20 January 2006 04:43

Maaher
Messages: 7065
Registered: December 2001

Senior Member

In that case, just create a database function that uses the SYS_CONTEXT function. Call this new function from Forms and you should be fine.

Something like this.
MHE

Report message to a moderator

Re: How to determine client IP address? [message #157204 is a reply to message #156017]

Wed, 01 February 2006 00:36

naeemjeewani
Messages: 3
Registered: January 2006

Junior Member

aight!!

thx

Report message to a moderator

Previous Topic:	I need boock
Next Topic:	alter database trigger in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 09:14:21 CST 2025