Re: IP address
From: Rajesh Jayaprakash <rajesh.j_at_vsnl.net>
Date: 18 Mar 2002 01:18:38 -0800
Message-ID: <59dd274f.0203180118.646347fc_at_posting.google.com>
Date: 18 Mar 2002 01:18:38 -0800
Message-ID: <59dd274f.0203180118.646347fc_at_posting.google.com>
"Pablo de Noguera" <pentapolin_at_miaulina.gat> wrote in message news:<a6spun$70n$1_at_talia.mad.ttd.net>...
> Hello,
>
> How can I get, in PL/SQL, the IP number of a connected client? It is
> possible?
>
> Thanks a lot.
I am not sure if there is an easier way than this, but you can call a native function using ORA_FFI. This function should call the underlying socket API function (gethost..()) to return the IP address.
Hope this helps.
Regards,
Rajesh Received on Mon Mar 18 2002 - 10:18:38 CET