SET_PROXY Procedure

This procedure sets the proxy to be used for requests of the HTTP or other protocols, excluding those for hosts that belong to the domain specified in no_proxy_domains. The proxy may include an optional TCP/IP port number at which the proxy server listens. The syntax is [http://]host[:port][/], for example, www-proxy.my-company.com:80. If the port is not specified for the proxy, port 80 is assumed. no_proxy_domains is a comma-, semi-colon-, or space-separated list of domains or hosts for which HTTP requests should be sent directly to the destination HTTP server instead of going through a proxy server. Optionally, a port number can be specified for each domain or host. If the port number is specified, the no-proxy restriction is only applied to the request at the port of the particular domain or host, for example, corp.my-company.com, eng.my-company.com:80. When no_proxy_domains is NULL and the proxy is set, all requests go through the proxy. When the proxy is not set, UTL_HTTP sends requests to the target Web servers directly.

Syntax

UTL_HTTP.set_proxy (

proxy             IN VARCHAR2,
no_proxy_domains  IN VARCHAR2);

Parameters

Table 78-9 shows the parameters for the SET_PROXY procedure.

Table 78-9 SET_PROXY Procedure Parameters

Parameter	Description
proxy (IN)	The proxy (host and an optional port number) to be used by the UTL_HTTP package
no_proxy_domains (IN)	The list of hosts and domains for which no proxy should be used for all requests.

Usage Notes

If proxy settings are set when the database server instance is started, the proxy settings in the environment variables http_proxy and no_proxy are assumed. Proxy settings set by this procedure override the initial settings.