Re: Finding the IP address of a web client

On Wed, 15 Aug 2001 09:15:10 +0300, Kostis Vezeridis <vezerid_at_komvos.edu.gr> wrote:

>I want my PL/SQL procedure to know the IP address of the client computer
>in a Web-deployed application. The web server clearly knows this address
>for responding. Can I have this address known to the PL/SQL code?
>
>TIA,
>Costis Vezeridis

Depending on which web server you're using, you need to do something like:

ip := substr(owa_util.get_cgi_env('REMOTE_ADDR'),1,128);

or

ip := substr(owa_util.get_cgi_env('REMOTE_HOST'),1,128);

I found iAS to use one name, and OAS/WebDB the other.

You can see all the available names to use in OWA_UTIL.GET_CGI_ENV by doing:

owa_util.print_cgi_env;

Hope this helps,
John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/