Oracle in a Nutshell

Calls

FUNCTION UTL_TCP.OPEN_CONNECTION (remote_host IN VARCHAR2, remote_port IN PLS_INTEGER, local_host IN VARCHAR2 DEFAULT NULL, local_port IN PLS_INTEGER DEFAULT NULL, in_buffer_size IN PLS_INTEGER DEFAULT NULL, out_buffer_size IN PLS_INTEGER DEFAULT NULL, charset IN VARCHAR2 DEFAULT NULL, newline DEFAULT CRLF, tx_timeout IN PLS_INTEGER DEFAULT NULL) RETURN CONNECTION;

Establishes a connection to remote_port on remote_host; if these parameters are NULL, uses local_port on local_host. Sets the sizes of the in and out buffers, the on-the-wire charset, the newline character sequence, and the tx_timeout (which is the amount of time the package will wait before abandoning a read or write operation). Returns a connection handle.

FUNCTION UTL_TCP.AVAILABLE (c IN OUT NOCOPY CONNECTION, timeout IN PLS_INTEGER DEFAULT 0) RETURN PLS_INTEGER;

Determines the amount of data available to read on c. Will wait for timeout seconds.

FUNCTION UTL_TCP.READ_RAW (c IN OUT NOCOPY CONNECTION, data IN OUT NOCOPY RAW, len IN PLS_INTEGER DEFAULT 1, peek IN BOOLEAN DEFAULT FALSE) RETURN PLS_INTEGER;

Reads slen bytes of raw data on c. If peek, data is left in the input queue. Returns the actual number of bytes received.

FUNCTION UTL_TCP.WRITE_RAW (c IN OUT NOCOPY CONNECTION, data IN RAW, len IN PLS_INTEGER DEFAULT NULL) RETURN PLS_INTEGER;

Writes binary data on c of len bytes. If len is NULL, all data is sent. Returns the actual number of bytes transmitted.

FUNCTION UTL_TCP.READ_TEXT (c IN OUT NOCOPY CONNECTION, ...