The CLOSE_CONNECTION procedure closes an open TCP/IP connection.
Applicability
This topic applies only to OceanBase Database in Oracle mode.
Syntax
UTL_TCP.CLOSE_CONNECTION (
c IN OUT NOCOPY connection);
Parameters
| Parameter | Description |
|---|---|
| c | The TCP/IP connection to be closed. |
Considerations
- You must close a connection that was opened by using the
open_connectionprocedure. After you close a connection, theremote_host,remote_port,local_host,local_port,charset, andprivate_sdfields are reset. - You must explicitly close an open connection. If the
connectionvariable goes out of scope, the connection is not automatically closed. - When a session is closed, all connections that were not explicitly closed are automatically closed.