What is the UTL_TCP Oracle supplied package?

What is the UTL_TCP Oracle supplied package?

Rating:

The UTL_TCP package enables PL/SQL applications to communicate with external TCP/IP-based servers by using TCP/IP. Because many Internet application protocols are based on TCP/IP, the UTL_TCP package is useful to PL/SQL applications that use Internet protocols.

The OPEN_CONNECTION function of the UTL_TCP package opens a TCP/IP connection with the specified remote and local host and port details. The remote host is the host providing the service. The remote port is the port number on which the service is listening for connections. The local host and port numbers represent those of the host providing the service. The OPEN_CONNECTION function returns a connection of PL/SQL record type.

The CLOSE_CONNECTION function of the UTL_TCP package closes an open TCP/IP connection. It takes the connection details of a previously opened connection as parameter. The CLOSE_ALL_CONNECTIONS procedure of the UTL_TCP package closes all open connections.

The READ_BINARY()/TEXT()/LINE() function of the UTL_TCP package receives binary, text, or text line data from a service on an open connection.

The WRITE_BINARY()/TEXT()/LINE() function of the UTL_TCP package transmits binary, text, or text line message to a service on an open connection.

Exceptions are raised when the buffer size for the input is too small, when generic network error occurs, when no more data is available to read from the connection, or when bad arguments are passed in a function call.

Rating: