0

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

1
  • 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. Commented Apr 8 at 14:13

2 Answers 2

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); 
Sign up to request clarification or add additional context in comments.

1 Comment

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

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

1 Comment

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.