ORA-24263: Certificate Error using slack_util_pkg on 12.2

[ajkruse]

When using slack_util_pkg on 12.2 I get the following error when trying to SEND_MESSAGE
ORA-24263: Certificate of the remote server does not match the target address.

Did some research to find: https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9536564700346663150

SOLUTION 

As of Oracle 12.2 the procedures of the utl_http package used to access remote webservices have a new parameter called https_host. One has to use this new parameter to avoid the error: 

For 12.2 the following can be added to slack_util_pkg as a fix/workaround
g_https_host string_util_pkg.t_max_db_varchar2 := 'slack.com';
...
, p_https_host => g_https_host
...

[mortenbra]

Thanks @ajkruse for pointing this out. As further explained in this post (http://lschilde.blogspot.no/2018/01/oracle-apex-and-122-upgrade.html) the p_https_host parameter was added to apex_web_service.make_rest_request in APEX version 5.1.4. So if you are on Oracle 12.2 you also need to upgrade to APEX 5.1.4 to be able to add this parameter.

Leaving this issue open as an enhancement for now.