CLOSE_CONNECTION

CLOSE_CONNECTION is used to close an open TCP/IP connection.

Syntax

UTL_TCP.CLOSE_CONNECTION (
   c IN OUT NOCOPY connection);

Parameters

Considerations

• The connection to be closed must have been opened using open_connection. After the connection is closed, the fields remote_host, remote_port, local_host, local_port, charset, and private_sd will be reset.
• Connections must be explicitly closed. The connection will not be automatically closed when the connection variable goes out of its lifecycle.
• Any connections that remain open will be automatically closed when the session is terminated.