The UTL_TCP package is USED by PL/SQL applications to access external Transmission Control Protocol/Internet Protocol (TCP/IP) based servers using the TCP/IP protocol.

The connection is opened using the OPEN_CONNECTION FUNCTION, which opens a TCP/IP connection when the REMOTE host, local host, and both the port numbers are specified. It returns a connection of PL/SQL RECORD type.

The connection is closed using the CLOSE_CONNECTION function, which closes the connection of the port whose details are PROVIDED as input.

The UTL_TCP package is used by PL/SQL applications to access external Transmission Control Protocol/Internet Protocol (TCP/IP) based servers using the TCP/IP protocol.

The connection is opened using the OPEN_CONNECTION function, which opens a TCP/IP connection when the remote host, local host, and both the port numbers are specified. It returns a connection of PL/SQL RECORD type.

The connection is closed using the CLOSE_CONNECTION function, which closes the connection of the port whose details are provided as input.