Re: UTL_INADDR package.

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Fri, 12 Mar 2004 06:22:30 GMT
Message-ID: <GGc4c.99287$Wa.3847@news-server.bigpond.net.au>

"AMIT" <kumar_929_at_yahoo.co.uk> wrote in message news:6f94b59f.0403112202.4bbd7a59_at_posting.google.com...
> Hi,
>
> I like to ask about the UTL_INADDR package.
> In order to use this package in my code should we prepare something
> before using this package.
> I mean should I grant some kind of privilege to the user or run some
> utility?
>
> Any response will be good.
>
> Kumar
>
>
> Sample
>
> utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')));

Kumar,

There appears to be no special privilege needed. There are no special requirements mentioned in the "Oracle9i Supplied PL/SQL Packages and Types Reference, Release 2 (9.2)" manual for this package. I tried a "SELECT utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')) FROM dual" without encountering any problems under 9.2.0.1 for my test user.

Douglas Hawthorne Received on Fri Mar 12 2004 - 00:22:30 CST