Hello There,
I hope you're doing well.
I'm trying to access a HTTPS link but I'm facing some errors
DECLARE
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
name VARCHAR2(256);
value VARCHAR2(1024);
BEGIN
UTL_HTTP.SET_PROXY('proxy.sys.test.uat.com', 'sys.test.uat.com');
req := UTL_HTTP.BEGIN_REQUEST('
https://sys.test.uat.com/yoghu/vicgap/updateStatus.json?id=1000'||'&'||'status=COMPLETED'||'&'||'userId=db' );
resp := UTL_HTTP.GET_RESPONSE(req);
DBMS_OUTPUT.PUT_LINE('HTTP response status code: ' || resp.status_code);
DBMS_OUTPUT.PUT_LINE('HTTP response reason phrase: ' || resp.reason_phrase);
UTL_HTTP.END_RESPONSE(resp);
END;
/
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-29259: end-of-input reached
ORA-06512: at line 8
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.