HTTP access for Oracle

Oracle leverages the UTL_HTTP package to provide access to HTTP tools.

The following code is online search, you can run directly in the Plsql.

Declare

Req Utl_http. REQ;
Resp Utl_http. RESP;
Val varchar2 (32767);
Begin

Req: = Utl_http. Begin_request (' http://www.sohu.com ');
Utl_http.set_header (req, ' content-type ', ' text/html; Charset=utf-8 ');--add this
RESP: = utl_http. Get_response (req);
Utl_http.read_line (Resp, Val, true);
Utl_http.end_response (RESP);
Dbms_output.put_line (Val);

EXCEPTION
When Utl_http.end_of_body Then
Utl_http.end_response (RESP);
End

If you just want to call a URL, you can use the following statement

Select Utl_http.request (' http://www.sohu.com ') from dual

The above content did not delve into, the time to study, first recorded

HTTP access for Oracle