Initiate ommunication with external TCP/IP-based servers using TCP/IP (Internet protocol).
Subprocedures:
connection
A PL/SQL record type used to represent a TCP/IP connection.
CRLF The character sequence carriage-return line-feed.
It is the newline sequence commonly used many communication standards.
open_connection Function
Open a TCP/IP connection to a specified service.
available Function
Determine the number of bytes available for reading from a TCP/IP connection.
read_raw Function
Receive binary data from a service on an open connection.
write_raw Function
Transmit a binary message to a service on an open connection.
read_text Function
Receive text data from a service on an open connection.
write_text Function
Transmit a text message to a service on an open connection.
read_line Function
Receive a text line from a service on an open connection.
write_line Function
Transmit a text line to a service on an open connection.
get_raw(), get_text(), get_line() Functions
Convenient forms of the read functions, which return
the data read instead of the amount of data read.
flush Transmit all data in the output buffer, if a buffer is used,
to the server immediately.
close_connection
Close an open TCP/IP connection.
close_all_connections
Close all open TCP/IP connections.
For full documentation of the packaged procedures
above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages
by Steven Feuerstein et al
"Computer Science is no more about computers than astronomy is about telescopes."
- E. W. Dijkstra
Related Commands:
Related Views: