Oracle in a Nutshell

HTTP requests

FUNCTION UTL_HTTP.BEGIN_REQUEST (url IN VARCHAR2, method IN VARCHAR2 DEFAULT 'GET', http_version IN VARCHAR2 DEFAULT NULL) RETURN REQ;

Begins a new HTTP request to url with method and http_version. Returns the req handle.

PROCEDURE UTL_HTTP.SET_HEADER (r IN OUT NOCOPY REQ, name IN VARCHAR2, value IN VARCHAR2);

Sets the request header name to value for request r.

PROCEDURE UTL_HTTP.SET_AUTHENTICATION (r IN OUT NOCOPY req, username IN VARCHAR2, password IN VARCHAR2, scheme IN VARCHAR2 DEFAULT 'Basic', for_proxy IN BOOLEAN DEFAULT FALSE);

Sets username/password for HTTP authentication scheme for request r. If for_proxy, identifies that authentication is for proxy server.

PROCEDURE UTL_HTTP.SET_COOKIE_SUPPORT (r IN OUT NOCOPY REQ, enable IN BOOLEAN DEFAULT TRUE);

Enables cookie support for request r.

PROCEDURE UTL_HTTP.SET_FOLLOW_REDIRECT (r IN OUT NOCOPY REQ, max_redirects IN PLS_INTEGER DEFAULT 3);

Changes the max_redirects request r inherits from default session setting.

PROCEDURE UTL_HTTP.SET_BODY_CHARSET (r IN OUT NOCOPY REQ, charset IN VARCHAR2 DEFAULT NULL);

Changes the charset request r inherits from default session setting.

PROCEDURE UTL_HTTP.SET_PERSISTENT_CONN_SUPPORT (r IN OUT NOCOPY REQ, enable IN BOOLEAN DEFAULT TRUE);

Enables persistent connection support for request r.

PROCEDURE UTL_HTTP.WRITE_TEXT (r IN OUT NOCOPY REQ, data IN VARCHAR2);

Writes data to HTTP request body for request r.

PROCEDURE UTL_HTTP.WRITE_LINE (r IN OUT NOCOPY REQ, data IN VARCHAR2); ...