Oracle in a Nutshell

HTTP session settings

PROCEDURE UTL_HTTP.SET_PROXY (proxy IN VARCHAR2, no_proxy_domains IN VARCHAR2);

Sets the proxy and can include the domains that will not use proxies at no_proxy_domains.

PROCEDURE UTL_HTTP.GET_PROXY (proxy OUT NOCOPY VARCHAR2, no_proxy_domains OUT NOCOPY VARCHAR2);

Gets the proxy and can include the domains that will not use proxies at no_proxy_domains.

PROCEDURE UTL_HTTP.GET_COOKIE_SUPPORT (enable IN BOOLEAN, max_cookies IN PLS_INTEGER DEFAULT 300, max_cookies_per_site IN PLS_INTEGER DEFAULT 20);

Sets whether or not cookies are enabled, the maximum number of cookies per session (max_cookies), and the maximum number of cookies per database (max_cookies_per_site).

PROCEDURE UTL_HTTP.SET_COOKIE_SUPPORT (enable OUT BOOLEAN, max_cookies OUT PLS_INTEGER, max_cookies_per_site OUT PLS_INTEGER);

Gets whether or not cookies are enabled, the maximum number of cookies per session (max_cookies), and the maximum number of cookies per database (max_cookies_per_site).

PROCEDURE UTL_HTTP.SET_FOLLOW_REDIRECT (max_redirects IN PLS_INTEGER DEFAULT 3);

Sets the maximum number of times a UTL_HTTP follows the HTTP redirect instruction.

PROCEDURE UTL_HTTP.GET_FOLLOW_REDIRECT (max_redirects OUT PLS_INTEGER);

Gets the maximum number of times a UTL_HTTP follows the HTTP redirect instruction.

PROCEDURE UTL_HTTP.SET_BODY_CHARSET (charset IN VARCHAR2 DEFAULT NULL);

Sets the default character set of the body of all future HTTP requests.

PROCEDURE UTL_HTTP.GET_BODY_CHARSET (charset OUT ...