Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Host IP Address from PL/SQL
This is IP address of the machine from which the client is connected.
For ip address database host use
SELECT utl_inaddr.get_host_address' FROM DUAL;
Jim DeCicco <decj1_at_interaccess.com> wrote in message
news:t72q4qrt57f5e5_at_corp.supernews.com...
> 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 Fri Jan 26 2001 - 06:30:05 CST