Re: Host IP Address from PL/SQL

Thanks! Unfortunately, it's not working on our database. The DBA is working with Oracle on the problem.

"Andrew Pahomov" <Pahomov_at_validio.com.ua> wrote in message news:3a716ecc$1_at_miik2-ilt.ilt.kharkov.ua...
>
> 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 Sun Jan 28 2001 - 08:53:09 CST