Home » Developer & Programmer » Forms » finding dataase server IP?
icon2.gif  finding dataase server IP? [message #214602] Wed, 17 January 2007 04:12 Go to next message
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member

is it possible to find the database server IP and the port number through forms using any packages?
Re: finding dataase server IP? [message #214659 is a reply to message #214602] Wed, 17 January 2007 07:17 Go to previous message
Messages: 129
Registered: September 2002
Senior Member
Find IP-ADDRESS of the Client/Database

SYS_CONTEXT('USERENV','IP_ADDRESS'); returns the IP address of the client.
SELECT HOST_NAME into var FROM V$INSTANCE ; returns the hostname into var of the database
UTL_INADDR.get_host_address(a); returns the IP address of the database

But if you want to find the IP Address of the machine where the database
resides , you can make use of V$INSTANCE .This is found in the Sys schema .
( for 8i and 9.0 databases)
One should make a view on this and grant select privleges to the forms users .
( for security reasons).
Previous Topic: [newbie] problem with non blocking show_window
Next Topic: Forms Error - FRM-40911
Goto Forum:

Current Time: Thu Jul 20 11:38:04 CDT 2017

Total time taken to generate the page: 0.06370 seconds