Obtaining Server IP in sub programs

[Raj Pod]

Hi,
I am working on a backend application and I would like to obtain the IP address of the server on which the tables reside. Can anyone help me with some suitable examples about the API that can be used to obtain the server ip in a trigger or stored procedure?
Thanks And Regards
Rajiv

[SJ Adnams]

v$instance has the hostname. is that any good to you?

[Raj Pod]

Hi,
Thanks for the information.
But for using the v$instance, the user has to be an administrator, right??? Will it work in stored procedures and triggers?
I went through the table. As you said, it gives the host name. Can I get the IP address, instead?
Rajiv

[SJ Adnams]

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgweb.htm#1005030
Getting a Host Name or Address from PL/SQL
You can determine the hostname of the local machine, or the IP address of a given hostname from a PL/SQL program or stored procedure using the UTL_INADDR package. You can find details about this package in the Oracle9i Supplied PL/SQL Packages and Types Reference. You use the results in calls to the UTL_TCP package.