Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: need computers IP Addresse - Data
Ban Spam wrote:
>
> "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!
Actually, it is UTL_TCP - and I don't believe it will get her what she
needs. She may need to write an EXTPROC to get it.
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Thu Sep 27 2001 - 22:06:27 CDT