Re: need computers IP Addresse - Data

From: Mark D Powell <mark.powell_at_eds.com>
Date: 28 Sep 2001 06:26:14 -0700
Message-ID: <178d2795.0109280526.375f8d73@posting.google.com>

Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns9129B71837E17SunnySD_at_24.0.3.73>...
> "Sabine.Buechel" <Sabine.Buechel_at_innosystec.de> wrote in news:9ovefn$qv8
> $05$1_at_news.t-online.com:
>
> > Hallo folks!
> > Need the IP Address as Information and Data.
> > How can I EASY get it? Is there a package for use, to get? Didn't see
> > something like that!
> >
> > Hope someone can give me advice.
> >
> > Thanks
> > Sabine
> >
>
> Since I don't have my Oracle Doc. set handy,
> I'm doing this from memory. For some flavors
> off V8 Oracle I think DBMS_SYSTEM will return
> some environmental variables.
>
> Alternatively with 8i+ I suspect that you could
> get this via DBMS_TCP.
>
> HTH & YMMV!
With Oracle version 8.1 the sys_context function will return the IP for a session.

UT1> select sys_context('USERENV','ip_address')   2 from sys.dual;

SYS_CONTEXT('USERENV','IP_ADDRESS')

---

xxx.xxx.6.4

 (ip hacked for security purposes)

• Mark D Powell --

Received on Fri Sep 28 2001 - 08:26:14 CDT