I'm using an Apex web service reference to access a third party restful webservice returning data in json format over https using Get. The pl/sql code uses the APEX_WEB_SERVICE API. The call as a url works in any browser and on my dev box, the web service reference also works. However, in the Oracle Cloud, the exact same code times out with ORA-12535. Is there any special permissions I need to have or configuration options I need to set?
This is a known issue caused by the instance proxy being incorrect currently. The fix is planned during the next maintenance window, but I don't have an exact time window for that. Once the proxy is in place, you should not have any issue using APEX_WEB_SERVICE.