The CLOSE_CONNECTION procedure is used to close 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
- The connection must have been opened by using the
open_connectionprocedure. After the connection is closed, theremote_host,remote_port,local_host,local_port,charset, andprivate_sdfields will be reset. - You must explicitly close the opened connection. The connection will not be automatically closed when the
connectionvariable goes out of scope. - If you do not close the connection before the session ends, it will be automatically closed when the session ends.
