ORA-29024: Certificate validation failure - When using UTL_HTTP.REQUEST From SQL Developer Web/ Apex
(Doc ID 2687222.1)
Last updated on FEBRUARY 29, 2024
Applies to:
Autonomous Database Serverless - Version N/A to N/AInformation in this document applies to any platform.
Symptoms
Customer was trying to follow the example mentioned in below document from Apex.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database-users.html#GUID-829A7D07-1EA4-4F59-AA60-F780FABAFDEC
Which failed with below error:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1810
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 639
ORA-06512: at "SYS.UTL_HTTP", line 1750
ORA-06512: at line 1
ORA-06512: at "SYS.UTL_HTTP", line 1810
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 639
ORA-06512: at "SYS.UTL_HTTP", line 1750
ORA-06512: at line 1
We have tested it in-house and it is working fine if you query through a standalone client like SQL Developer. And it failed with the above error while running from SQL Developer Web.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |