Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
UTL_HTTP , 56 of 59
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;
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);
Table 78-51 shows the parameters for the CLOSE_PERSISTENT_CONNS
procedure.
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.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|