close_connection Procedure

This procedure closes an open TCP/IP connection.

Syntax

UTL_TCP.close_CLOSE_CONNECTION (c IN OUT NOCOPY connection);

Parameters

Table 83-14 close_connection Procedure Parameters

Parameter	Description
c (IN OUT NOCOPY)	The TCP connection to close.

Usage Notes

Connection must have been opened by a previous call to open_connection(). The fields remote_host, remote_port, local_host, local_port and charset of c will be reset after the connection is closed.

An open connection must be closed explicitly. An open connection will remain open when the PL/SQL record variable that stores the connection goes out-of-scope in the PL/SQL program. Failing to close unwanted connections may result in unnecessary tying up of local and remote system resources.