Proxy authentication with UTL

From: <matthew_d_keene_at_my-deja.com>
Date: Mon, 11 Dec 2000 04:14:45 GMT
Message-ID: <911kbi$ftt$1@nnrp1.deja.com>

Does anybody know if it's possible to do proxy authentication with UTL_HTTP ? I'm getting the following results trying to use the package:

ORDAS > select utl_http.request('http://www.oracle.com') from dual ;

UTL_HTTP.REQUEST('http://WWW.ORACLE.COM')

<HTML>
<HEAD><TITLE>ERROR: The requested URL could not be
retrieved</TITLE></HEAD>
<META charset=ISO-8859-1>
<BODY BGCOLOR=#FFFFFF TEXT=#000000>
<H2>ERROR: The requested URL could not be retrieved</H2>
<HR>
<P>

While trying to retrieve the URL:
http://www.oracle.com
<P>

The following error was encountered:

UTL_HTTP.REQUEST('http://WWW.ORACLE.COM')

<UL>
<LI><STRONG>ERROR 119 -- You are not authorized to access the proxy-
cache server
.</STRONG>
</UL>
<P>This means that:
<P>
<TT>

If you think that you are authorized, try entering the password again.
</TT>
<P> <HR>


UTL_HTTP.REQUEST('http://WWW.ORACLE.COM')

</BODY></HTML>

I've set the environment variables http_proxy, http_proxy_user and http_proxy_pass to the appropriate values for my proxy address, userid and password, but I don't seem to be having any luck.

Any ideas ?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Dec 10 2000 - 22:14:45 CST

Proxy authentication with UTL_HTTP