OAR-12345: TNS: Operation Timed out when accessing HTTP callout using UTL_HTTP

Hi All,

We are doing an integration to Oanda to get GL Daily rates into Oracle R12.1.3.

If I type the below link in Web browser then I am able to get Rates in CSV format from Oanda. I am using the same link from PL/SQL code but I get the below error. Any suggestion would be great.

ERROR MESSAGE:

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1130

ORA-12535: TNS:operation timed out

ORA-06512: at line 7

CODE:

SET DEFINE OFF

SET SERVEROUTPUT ON

DECLARE

  req UTL_HTTP.REQ;

  resp UTL_HTTP.RESP;

  value VARCHAR2(32767);

  V_DATA VARCHAR2(100) := 'strDate=”11-MAY-2015”';