December 2002
Intermediate to advanced
928 pages
85h 29m
English
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, ...