Oracle provides PL/SQL UTL_HTTP package for calling HTTP from Oracle database. While using UTL_HTTP, it is required to set the proxy settings when calling a URL which is out side the firewall or beyond the proxy. In order to set the proxy, Oracle provides the following methods to set the proxy information.
Utl_Http.Set_Proxy (
proxy => ‘yourproxy’,
no_proxy_domains => ‘yourdomains’ );req := Utl_Http.Begin_Request (
url => v_url,
method => ‘GET’ );Utl_Http.Set_Authentication (
r => req,
username => ‘username’,password => ‘password’,
scheme => ‘Basic’,
for_proxy => false );