UTL_HTTP call to https site fails ORA-28750: Unknown Error after Upgrade To 12.2, But works in 12.1 DB
(Doc ID 2459858.1)
Last updated on JULY 20, 2024
Applies to:
PL/SQL - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]Advanced Networking Option - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.
Symptoms
utl_http fails with "ORA-28750: unknown error" after upgrading to 12.2 database.
The same utl_http was working fine in 12.1 version
SQL> SELECT UTL_HTTP.request ('https://************','<proxy server>:<port>','file:<wallet path>','<wallet password>') FROM DUAL;
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-28750: unknown error
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 1
Changes
With SNI support starting in 12.2, validate certificate sent back from the server with the host name may fail when it should have passed.
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 |
| Changes |
| Cause |
| Solution |
| References |