Hello,
I have two databases using Oracle 11 and 18.
I am trying to run the following utl_http.request on both, an get the same error:
select utl_http.request('https://pubchem.ncbi.nlm.nih.gov/rest/pug/compound/cid/2244')
from dual;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1530
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1470
ORA-06512: at line 1
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.
I have found some information where it says that I need to create an oracle wallet, and I need a token or certificate from the website I make the request. So I talked to PubChem and they said that they do not use tokens or certificates for their http services.
So can you help me here? How do I create the wallet without this information?
Thanks in advance for any help you can give me,
Blanca Hembre