Re: Host IP Address from PL/SQL

Andrew Pahomov <Pahomov_at_validio.com.ua> wrote in message news:3a716dcc$1_at_miik2-ilt.ilt.kharkov.ua...
> 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;

Sorry for                                                      ^

Correct:
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:34:21 CST