How to Set a Connection Timeout When Using UTL_HTTP (or UTL_SMTP) (Doc ID 760664.1)

Last updated on AUGUST 04, 2017

Applies to:

PL/SQL - Version 11.1.0.6 and later
Information in this document applies to any platform.
*** Checked for relevance on 5th Aug 2017 ***

Symptoms

You are using UTL_HTTP to call a web service.  If the web service is down it may take approximately 4-8 minutes for control to return back to the PL/SQL program with a timed out response.  You want to know if there is a way to reduce the connection timeout when calling a web service using the Oracle Supplied Package UTL_HTTP.

NOTE:  UTL_HTTP contains a procedure called SET_TRANSFER_TIMEOUT.  While this may appear to be a way to set a connection timeout a closer look at the documentation explains that this procedure is for subsequent HTTP request-responses over that same connection once you have successfully established a connection to the web service.  So, this does not satisfy our need to set a timeout for the initial connection to the web service.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms