You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for UTL_TCP


1 to 20 of 75 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 1 of 2

101 UTL_TCPWith 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Summary of UTL_TCP SubprogramsTable 101-2 UTL_TCP Subprograms Subprogram Description connection A PL/SQL record type used to

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

SyntaxUTL_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;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

flush ProcedureThis procedure transmits all data in the output buffer, if a buffer is used, to the server immediately.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

connectionThis is a PL/SQL record type used to represent a TCP/IP connection.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Related Functionsread_raw(), read_text(), read_line()

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Usage NotesThe connection must have already been opened through a call to open_connection().

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Usage NotesThe 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,

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

ParametersTable 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

SyntaxUTL_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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

CRLFThe character sequence carriage-return line-feed. It is the newline sequence commonly used many communication standards.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Related Functionsclose_connection(), close_all_connections()

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

FieldsUTL_TCP package waits before giving up in a read or write operation in this connection. In read

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

SyntaxUTL_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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

SyntaxUTL_TCP.AVAILABLE ( c IN OUT NOCOPY connection, timeout IN PLS_INTEGER DEFAULT 0) RETURN PLS_INTEGER;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Usage NotesThe 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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

SyntaxUTL_TCP.FLUSH (c IN OUT NOCOPY connection);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

available FunctionThis 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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

SyntaxUTL_TCP.CLOSE_ALL_CONNECTIONS;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_TCP, 2 of 2

Related Functionsopen_connection(), close_connection() Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback