Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_http get header details

1055358Aug 11 2016 — edited Aug 12 2016

Hi ,

I have attached the Service request image herewith. How can i get this headers from the web service via my package :

DECLARE

t_http_req utl_http.req;

t_http_resp utl_http.resp;

t_response_text VARCHAR2 (2000);

begin

t_http_req:= utl_http.begin_request('www.abc.com/V2IDSDev/api/User/GetUsers/BIZZXE_ERP_V2','GET','HTTP/1.1');

t_http_resp:= utl_http.get_response(t_http_req);

UTL_HTTP.read_text(t_http_resp, t_response_text);

DBMS_OUTPUT.put_line('Response> status_code: "' || t_http_resp.status_code || '"');

utl_http.end_response(t_http_resp);

end;

request.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2016
Added on Aug 11 2016
7 comments
6,401 views