My Oracle Support Banner

UTL_HTTP.SET_TRANSFER_TIMEOUT with wrong Proxy Port does not work (Doc ID 420994.1)

Last updated on APRIL 09, 2020

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 27 Nov 2018***

Symptoms

When using UTL_HTTP.SET_TRANSFER_TIMEOUT and there is a Proxy with wrong port, it does not recognize the set timeout. Error ORA-12541 or ORA-12535 occurs.

Code sample:

set serverout on
declare
  vPieces utl_http.html_pieces;
begin
  UTL_HTTP.SET_TRANSFER_TIMEOUT (timeout => 10);
  vPieces := utl_http.request_pieces(url => 'http://www.oracle.com', proxy => 'proxy address:port');      -- wrong proxy port
  dbms_output.put_line(substr(vPieces(1),1,250));
end;
/

SQL> @test
declare
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1670
ORA-12541: TNS:no listener (or ORA-12535: TNS:operation timed out)
ORA-06512: at line 5

 

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

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