CLOSE_PERSISTENT_CONNS Procedure

This procedure closes a group of HTTP persistent connections maintained by the UTL_HTTP package in the current database session. This procedure uses a pattern-match approach to decide which persistent connections to close.

To close a group of HTTP persistent connection that share a common property (for example, all connections to a particular host, or all SSL connections), set the particular parameters and leave the rest of the parameters NULL. If a particular parameter is set to NULL when this procedure is called, that parameter will not be used to decide which connections to close.

For example, the following call to the procedure closes all persistent connections to foobar:

utl_http.close_persistent_conns(host => 'foobar');

And the following call to the procedure closes all persistent connections via the proxy www-proxy at TCP/IP port 80:

utl_http.close_persistent_conns(proxy_host => 'foobar',
                                proxy_port => 80);

And the following call to the procedure closes all persistent connections:

utl_http.close_persistent_conns;

Syntax

UTL_HTTP.close_persistent_conns (

host  IN VARCHAR2 DEFAULT NULL,
port  IN PLS_INTEGER DEFAULT NULL,
proxy_host  IN VARCHAR2 DEFAULT NULL,
proxy_port IN PLS_INTEGER DEFAULT NULL,
ssl  IN BOOLEAN DEFAULT NULL);

Parameters

Table 78-51 shows the parameters for the CLOSE_PERSISTENT_CONNS procedure.

Table 78-51 CLOSE_PERSISTENT_CONNS Procedure Parameters

Parameter	Description
host (IN)	The host for which persistent connections are to be closed
port (IN)	The port number for which persistent connections are to be closed
proxy_host (IN)	The proxy host for which persistent connections are to be closed
proxy_port (IN)	The proxy port for which persistent connections are to be closed
ssl (IN)	Close persistent SSL connection

Usage Notes

Connections to the same Web server at different TCP/IP ports are counted individually. The host names of the Web servers are identified as specified in the URL of the original HTTP requests. Therefore, fully qualified host names with domain names will be counted differently from the host names without domain names.

Note that the use of a NULL value in a parameter when this procedure is called means that the caller does not care about its value when the package decides which persistent connection to close. If you want a NULL value in a parameter to match only a NULL value of the parameter of a persistent connection (which is when you want to close a specific persistent connection), you should use the close_persistent_conn procedure that closes a specific persistent connection.