PL/SQL Packages UTL_TCP

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: