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_HTTP


1 to 20 of 223 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_HTTP, 1 of 2

UTL_HTTP ExamplesThe following examples demonstrate how to use UTL_HTTP. Example: Using UTL_HTTP SET serveroutput ON … UTL_HTTP CREATE OR REPLACE FUNCTION save_cookies RETURN BINARY_INTEGER AS cookies utl_http.cookie_table … my_session_id; END; REM Retrieve cookies from UTL_HTTP CREATE OR REPLACE PROCEDURE restore_cookies

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

UTL_HTTP, 1 of 2

UTL_HTTP FlowThe UTL_HTTP package provides access to the HTTP protocol. The API must be called in the order … shown in Figure 96-1, or an exception will be raised. Figure 96-1 Flow of the Core UTL_HTTP Package Text … APIs that manipulate attributes and configurations of the UTL_HTTP package in the current session … retrieve the last detailed

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

UTL_HTTP, 1 of 2

96 UTL_HTTPThe UTL_HTTP package makes Hypertext Transfer Protocol (HTTP) callouts from SQL and PL/SQL. You can … use it to access data on the Internet over HTTP. With UTL_HTTP, you can write PL/SQL programs that … communicate with Web (HTTP) servers. UTL_HTTP also contains a function that can be used in SQL … for more information on Wallet

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

UTL_HTTP, 1 of 2

UTL_HTTP ExceptionsTable 96-5 lists the exceptions that the UTL_HTTP package API can raise. By default, UTL_HTTP … regardless of the setting). Table 96-5 UTL_HTTP Exceptions Exception Error Code Reason Where Raised … illegal_call 29267 The call to UTL_HTTP is illegal at the current state of the HTTP request

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

UTL_HTTP, 2 of 2

Summary of UTL_HTTP SubprogramsTable 96-6  UTL_HTTP Subprograms--Simple HTTP Fetches in a Single Call Subprogram Description … pieces of the data retrieved from the given URL. Table 96-7  UTL_HTTP Subprograms--Session Settings … cookie support settings SET_FOLLOW_REDIRECT Procedure Sets the maximum number of times UTL_HTTP follows … Sets the UTL_HTTP

Getting Started, 9i Release 2 (9.2.0.2)

Developing Applications for Windows

UTL_HTTP Exception Conditionsexceptions: create or replace package utl_http is function request (url in varchar2) return varchar2 … RESTRICT_REFERENCES enables display of exceptions: create or replace package utl_http is type html_pieces is

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Packages

About the UTL_HTTP PackagePackage UTL_HTTP allows your PL/SQL programs to make hypertext transfer protocol (HTTP) callouts

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

UTL_HTTP, 1 of 2

UTL_HTTP Constants, Types and FlowUTL_HTTP Constants Table 96-1 UTL_HTTP Constants Constant and Syntax Purpose HTTP_VERSION_1_0 … ; - HTTP_VERSION_NOT_SUPPORTED CONSTANT PLS_INTEGER:= 505;- UTL_HTTP Types Use the following types with UTL_HTTP. REQ Type Use … private_. The fields are private and are intended for use by implementation of the UTL_HTTP

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

UTL_HTTP, 2 of 2

GET_PERSISTENT_CONN_SUPPORT ProcedureThis procedure checks: If the persistent connection support is enabled Gets the maximum number of persistent connections in the current session

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

UTL_HTTP, 2 of 2

SET_BODY_CHARSET ProcedureThis procedure sets the character set of the response body when the media type is "text" but the character set is not specified in the "Content-Type" header. For each the HTTP protocol standard specification, if the media type of a request or a response is "text" but the character set information is missing in the "Content-Type" header, the character set of the request or response body should default

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

UTL_HTTP, 2 of 2

GET_COOKIES FunctionThis function returns all the cookies currently maintained by the UTL_HTTP package set by all Web servers.

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

UTL_HTTP, 2 of 2

GET_TRANSFER_TIMEOUT ProcedureThis procedure retrieves the default timeout value for all future HTTP requests.

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

UTL_HTTP, 2 of 2

ParametersTable 96-31 GET_TRANSFER_TIMEOUT Procedure Parameters Parameter Description TIMEOUT (OUT) The network transfer timeout value in seconds.

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

UTL_HTTP, 2 of 2

SyntaxUTL_HTTP.get_authentication( r IN OUT NOCOPY resp, scheme OUT VARCHAR2, realm OUT VARCHAR2, for_proxy IN BOOLEAN DEFAULT FALSE);

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

UTL_HTTP, 2 of 2

Parametersif UTL_HTTP raises a detailed exception; otherwise FALSE

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

UTL_HTTP, 2 of 2

SyntaxUTL_HTTP.set_detailed_excp_support ( enable IN BOOLEAN DEFAULT FALSE);

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

UTL_HTTP, 2 of 2

SyntaxUTL_HTTP.write_raw( r IN OUT NOCOPY req, data IN RAW);

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

UTL_HTTP, 2 of 2

READ_TEXT ProcedureThis procedure reads the HTTP response body in text form and returns the output in the caller-supplied buffer. The end_of_body exception will be raised if the end of the HTTP response body is reached. Text data is automatically converted from the response body character set to the database character set.

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

UTL_HTTP, 2 of 2

ParametersTable 96-50 READ_LINE Procedure Parameters Parameter Description r (IN/OUT) The HTTP response. data (OUT) The HTTP response body in text form remove_crlf (IN) Removes the newline characters if set to TRUE

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

UTL_HTTP, 2 of 2

SET_COOKIE_SUPPPORT ProcedureThis procedure enables or disables support for the HTTP cookies in the request. If cookie support is enabled for an HTTP request, all cookies saved in the current session and applicable to the request are returned to the Web server in the request in accordance with HTTP cookie specification standards. Cookies set in the response to the request are saved in the current session for return to the Web