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
UTL_HTTP Examples → The 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
UTL_HTTP Flow → The 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
96 UTL_HTTP → The 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
UTL_HTTP Exceptions → Table 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
Summary of UTL_HTTP Subprograms → Table 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
UTL_HTTP Exception Conditions → exceptions: 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
About the UTL_HTTP Package → Package UTL_HTTP allows your PL/SQL programs to make hypertext transfer protocol (HTTP) callouts
UTL_HTTP Constants, Types and Flow → UTL_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
GET_PERSISTENT_CONN_SUPPORT Procedure → This procedure checks: If the persistent connection support is enabled Gets the maximum number of persistent connections in the current session
SET_BODY_CHARSET Procedure → This 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
GET_COOKIES Function → This function returns all the cookies currently maintained by the UTL_HTTP package set by all Web servers.
GET_TRANSFER_TIMEOUT Procedure → This procedure retrieves the default timeout value for all future HTTP requests.
Parameters → Table 96-31 GET_TRANSFER_TIMEOUT Procedure Parameters Parameter Description TIMEOUT (OUT) The network transfer timeout value in seconds.
Syntax → UTL_HTTP.get_authentication( r IN OUT NOCOPY resp, scheme OUT VARCHAR2, realm OUT VARCHAR2, for_proxy IN BOOLEAN DEFAULT FALSE);
Parameters → if UTL_HTTP raises a detailed exception; otherwise FALSE
Syntax → UTL_HTTP.set_detailed_excp_support ( enable IN BOOLEAN DEFAULT FALSE);
Syntax → UTL_HTTP.write_raw( r IN OUT NOCOPY req, data IN RAW);
READ_TEXT Procedure → This 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.
Parameters → Table 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
SET_COOKIE_SUPPPORT Procedure → This 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