Re: How to get hostname in PL/SQL

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Fri, 05 Jan 2001 11:38:49 +0300
Message-ID: <3A558819.AD0D78A@bill.mts.ru>

Jarek Palka wrote:
> > Olivier Bercovitz wrote in message <9308ok$qeq$1_at_front5.grolier.fr>...
> > >Is there a way to know the hostname (or the IP adress) in a PL/SQL

Begining Oracle8i (8.1.6) you cann use function SYS_CONTEXT. It can be used in SQL or PL/SQL

  For example
   SELECT
      SYS_CONTEXT (’USERENV’, ’HOST’) "User Host"     , SYS_CONTEXT (’USERENV’, ’IP_ADDRESS’) "User IP address"    FROM DUAL; Valery Yourinsky Received on Fri Jan 05 2001 - 02:38:49 CST