Home » RDBMS Server » Server Administration » How to get the ipadress of the terminals connected to oracle
How to get the ipadress of the terminals connected to oracle [message #369526] Thu, 12 October 2000 13:34 Go to next message
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
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 Go to previous messageGo to next message
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');
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 Go to previous messageGo to next message
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');
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 Go to previous message
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
Previous Topic: ip address
Next Topic: search for & in a string
Goto Forum:
  


Current Time: Thu Mar 28 07:08:47 CDT 2024