Hi Everyone,
We have a DB 12cR1
ACLs are granted :
But we are unable to call an API with PL/SQL using UTL_HTTP
declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
val VARCHAR2(2000);
str varchar2(1000);
begin
req := UTL_HTTP.BEGIN_REQUEST('https://ion.tdsynnex.com/api/v1/invoices/myinvoices');
resp := UTL_HTTP.GET_RESPONSE(req);
LOOP
UTL_HTTP.READ_LINE(resp, val, TRUE);
DBMS_OUTPUT.PUT_LINE(val);
END LOOP;
UTL_HTTP.END_RESPONSE(resp);
EXCEPTION
WHEN UTL_HTTP.END_OF_BODY THEN
UTL_HTTP.END_RESPONSE(resp);
END;
/
And we always got following error :
Rapport d'erreur -
ORA-29273: échec de demande HTTP
ORA-29024: Echec de validation de certificat
ORA-06512: à "SYS.UTL_HTTP", ligne 368
ORA-06512: à "SYS.UTL_HTTP", ligne 1118
I tried to follow this doc https://oracle-base.com/articles/misc/utl_http-and-ssl to create a wallet
and added utl_http.set_wallet('file:D:\Wallet\wallet\', null);
before to call req := UTL_HTTP.BEGIN_REQUEST('https://ion.tdsynnex.com/api/v1/invoices/myinvoices');
But we still got same issue
We read about My Oracle Support Doc ID 756978.1 that we should use a PROXY
But we didn't have any proxy AND this Doc ID is related to DB 19c and we are in an older version so I guess it should not apply?
Thanks
Best regards,