Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Host IP Address from PL/SQL
Does that give me the user's address, or the host address? I need the host address.
Thanks!
"Andrew Pahomov" <Pahomov_at_validio.com.ua> wrote in message
news:3a712cbd$1_at_miik2-ilt.ilt.kharkov.ua...
> SELECT SYS_CONTEXT('USERENV', 'IP_ADDRESS') FROM DUAL;
>
>
> Jim DeCicco <decj1_at_interaccess.com> wrote in message
> news:t71jtc978l1te5_at_corp.supernews.com...
> > Any info. would be greatly appreciated. I want to create a function that
> > will return the IP address of the UNIX host that the database is running
on.
> > I know that I can get the host name from v$instance, but I need the
address.
> > We're running 8.1.6 on HP-UX (not sure of the version).
> >
> > Do I have to write a C program, create a library, etc?
> >
> > Thanks in advance
> >
> > Jim
> >
> >
>
>
Received on Sat Jan 27 2001 - 06:05:03 CST