ORA-29270: too many open HTTP requests while calling webservice from pl/sql procedure

Question

I am invoking a webservice from PL/SQL procedure ,while executing the procedure after 5 times I am getting the below error ,any help will be appreciated.

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1367 ORA-29270: too many open HTTP requests

This question is similar to: ORA-29270: too many open HTTP requests. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — bmaupin
– bmaupin, Commented Apr 8 at 14:13

Kaushik Nayak · Accepted Answer · 2018-03-02 16:25:57Z

1

you need to close your requests once you are done with them, it does not happen automatically (unless you disconnect form the db entirely)

It used to be utl_http.end_response, but I am not sure if it is the same api any more. Raise an exception when there are more incoming requests as below

EXCEPTION
  WHEN TOO_MANY_REQUESTS THEN
  END_RESPONSE(resp);

edited Mar 2, 2018 at 16:25

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

answered Mar 2, 2018 at 14:44

Kamal Vamsi

1284 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gablu Over a year ago

Actually we are not receiving any response from the webservice ,this webservice is just insert records into another table

Md Faramawy · Accepted Answer · 2018-12-17 07:07:45Z

1

I faced the same problem , and solved it by Disconnecting from Database and reConnecting

answered Dec 17, 2018 at 7:07

Md Faramawy

275 bronze badges

1 Comment

Evan Over a year ago

It works for me! It seems you must disconnect the DB to end the opened http request you already submitted

Collectives™ on Stack Overflow

ORA-29270: too many open HTTP requests while calling webservice from pl/sql procedure

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related