My Oracle Support Banner

ORA-20001 / ORA-12535 When Running a Secure Web Service (HTTPS) from APEX (Doc ID 1499549.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.0.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a web service through APEX, the following error occurs:

ORA-20001: The webservice was unreachable because either the URL you supplied was invalid, your environment requires a valid proxy server address for HTTP requests, the request timed out, or a wallet needs to be configured for HTTPS requests.

 

SELECT utl_http.request('http://www.oracle.com') from DUAL;

SELECT utl_http.request('https://some.webservice.com/services/LoginService',NULL,'file:/home/oracle/app/oracle/product/11.2.0/dbhome_2/owm/wallets/oracle','OracleWallet123') from dual;

 This request receives error:  ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1722 ORA-12535: TNS: operation timed out

The same request runs successfully in SQL Developer.

 



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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.