OraFAQ Forum: Server Administration » How to get the ipadress of the terminals connected to oracle

Home » RDBMS Server » Server Administration » How to get the ipadress of the terminals connected to oracle

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

How to get the ipadress of the terminals connected to oracle [message #369526]

Thu, 12 October 2000 13:34

Gokul
Messages: 21
Registered: October 2000

Junior Member

is there any direct way of getting the ipaddress of the terminal connected to oracle. Iknow that we can get the terminal name from the v_$session table . But is there any way of getting the ipaddress of the terminal. WIll someone help me in the question

Report message to a moderator

Re: How to get the ipadress of the terminals connected to oracle [message #369542 is a reply to message #369526]

Mon, 16 October 2000 14:34

meera
Messages: 5
Registered: February 2000

Junior Member

TO get the ip address
declare a variable and assign the result as follows

eg: remote_ip :=owa_util.get_cgi_env('REMOTE_ADDR');

Report message to a moderator

Re: How to get the ipadress of the terminals connected to oracle [message #369543 is a reply to message #369526]

Mon, 16 October 2000 14:34

meera
Messages: 5
Registered: February 2000

Junior Member

TO get the ip address
declare a variable and assign the result as follows

eg: remote_ip :=owa_util.get_cgi_env('REMOTE_ADDR');

Report message to a moderator

Re: How to get the ipadress of the terminals connected to oracle [message #369544 is a reply to message #369526]

Mon, 16 October 2000 15:10

Raghavendra M.K.
Messages: 10
Registered: September 2000

Junior Member

Hi meera,

I did not found the package "owa_util"

with which version of oracle this package comes

Thanks

Raghu

Report message to a moderator

Previous Topic:	ip address
Next Topic:	search for & in a string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 16:04:31 CST 2024