Skip to main content
 

Chiamata URL da PL/SQL

Il package da utilizzare si chiama UTL_URL, qui la documentazione Oracle ufficiale.

Codice di esempio:

declare 
 req   UTL_HTTP.REQ;
 resp  UTL_HTTP.RESP;
 value VARCHAR2(1024);
BEGIN
 UTL_HTTP.SET_PROXY('proxy.my-company.com', 'corp.my-company.com');
 req := UTL_HTTP.BEGIN_REQUEST('http://...............');
 UTL_HTTP.SET_HEADER(req, 'User-Agent', 'Mozilla/4.0');
 resp := UTL_HTTP.GET_RESPONSE(req);
 LOOP
 UTL_HTTP.READ_LINE(resp, value, TRUE);
 DBMS_OUTPUT.PUT_LINE(value);
 END LOOP;
 UTL_HTTP.END_RESPONSE(resp);
EXCEPTION
 WHEN UTL_HTTP.END_OF_BODY THEN
 UTL_HTTP.END_RESPONSE(resp);
END;