How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
101 UTL_TCP → With the UTL_TCP package and its procedures and functions, PL/SQL applications can communicate with … UTL_TCP package provides TCP/IP client-side access functionality in PL/SQL. The API provided in the … topics: Exceptions Example Summary of UTL_TCP Subprograms
Summary of UTL_TCP Subprograms → Table 101-2 UTL_TCP Subprograms Subprogram Description connection A PL/SQL record type used to
Syntax → 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 IN VARCHAR2 DEFAULT CRLF, tx_timeout IN PLS_INTEGER DEFAULT NULL) RETURN connection;
flush Procedure → This procedure transmits all data in the output buffer, if a buffer is used, to the server immediately.
connection → This is a PL/SQL record type used to represent a TCP/IP connection.
Related Functions → read_raw(), read_text(), read_line()
Usage Notes → The connection must have already been opened through a call to open_connection().
Usage Notes → The connection must have already been opened through a call to open_connection(). Users may use this API to determine if data is available to be read before calling the read API so that the program will not be blocked because data is not ready to be read from the input. The number of bytes available for reading returned by this function may less than than what is actually available. On some platforms,
Parameters → Table 101-6 read_raw Function Parameters Parameter Description c (IN OUT NOCOPY) The TCP connection to receive data from. data (IN OUT COPY) The data received. len (IN) The number of bytes of data to receive. peek (IN) Normally, you want to read the data and remove it from the input queue, that is, consume it. In some situations, you may just want to look ahead at the data, that is, peek at it, without
Syntax → UTL_TCP.READ_TEXT (c IN OUT NOCOPY connection, data IN OUT NOCOPY VARCHAR2, len IN PLS_INTEGER DEFAULT 1, peek IN BOOLEAN DEFAULT FALSE) RETURN PLS_ INTEGER; Table 101-8 read_text Function Parameters Parameter Description c (IN OUT NOCOPY) The TCP connection to receive data from. data (IN OUT NOCOPY) The data received. len (IN) The number of characters of data to receive. peek (IN) Normally, users
CRLF → The character sequence carriage-return line-feed. It is the newline sequence commonly used many communication standards.
Related Functions → close_connection(), close_all_connections()
Fields → UTL_TCP package waits before giving up in a read or write operation in this connection. In read
Syntax → UTL_TCP.WRITE_TEXT (c IN OUT NOCOPY connection, data IN VARCHAR2, len IN PLS_INTEGER DEFAULT NULL) RETURN PLS_INTEGER; Table 101-9 write_text Function Parameters Parameter Description c (IN OUT NOCOPY) The TCP connection to send data to. data (IN) The buffer containing the data to be sent. len (IN) The number of characters of data to transmit. When len is NULL, the whole length of data is written.
Syntax → UTL_TCP.AVAILABLE ( c IN OUT NOCOPY connection, timeout IN PLS_INTEGER DEFAULT 0) RETURN PLS_INTEGER;
Usage Notes → The connection must have already been opened through a call to open_connection(). Text messages will be converted to the on-the-wire character set, specified when the connection was opened, before they are transmitted on the wire.
Syntax → UTL_TCP.FLUSH (c IN OUT NOCOPY connection);
available Function → This function determines the number of bytes available for reading from a TCP/IP connection. It is the number of bytes that can be read immediately without blocking. Determines if data is ready to be read from the connection.
Syntax → UTL_TCP.CLOSE_ALL_CONNECTIONS;