UTL_HTTP.REQUEST URL authentication

I imported the certificate to mydomain.com in oracle wallet manager, besides the certificate, i have to login to mydomain.com with a username / password


When I use

SELECT UTL_HTTP.REQUEST(url => 'https://app.mydomain.com/api/v2/app?format=XML',proxy => null,wallet_path =>'file:/home/oracle/app/oracle/product/12.1.0/dorasnat/owm/wallets/oracle',wallet_password => 'mypass') FROM DUAL;

Open in new window


I get

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29024: Certificate validation failure
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.

Open in new window


where in the process do i input the credentials so that i can get to the XML feed?
FutureDBA-Asked:
Who is Participating?
 
Praveen Kumar ChandrashekatrConnect With a Mentor Database Analysist Senior Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.