Getting UTL_HTTP.TOO_MANY_REQUESTS Even When Request Is Closed In Same Function/procedure (Doc ID 1905350.1)

Last updated on MAY 15, 2016

Applies to:

PL/SQL - Version 11.2.0.3 and later
Information in this document applies to any platform.
*** Checked for relevance on 16th May 2016***

Symptoms

Getting UTL_HTTP.TOO_MANY_REQUESTS after 5 requests, even though the HTTP connections are being opened and closed in the same procedure.

Error report -
ORA-29270: too many open HTTP requests
ORA-06512: at "SYS.UTL_HTTP", line 243
ORA-06512: at "SYS.UTL_HTTP", line 1098
ORA-06512: at "PACKAGE.PROCEDURE", line 39

Changes

Verify if you are using UTL_HTTP.CREATE_REQUEST_CONTEXT to create context for UTL_HTTP connections.

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