Thanks for the question, Senthilnathan.
Asked: June 07, 2023 - 7:31 am UTC
Last updated: June 08, 2023 - 6:48 am UTC
Version: 12c
Viewed 1000+ times
You Asked
Hi,
I am using APEX_WEB_SERVICE.MAKE_REQUEST instead of utp_http package to consume rest api calls. Is there are way to close APEX_WEB_SERVICE.MAKE_REQUEST similar to UTL_HTTP.END_RESPONSE?
I am getting ORA-29270: too many open HTTP requests (more than 5), need to call the api due to pagination but the oracle limitation is not allowing.
I was under the impression that APEX_WEB_SERVICE.MAKE_REQUEST does the opening and ending response automatically.
Thank you
and Connor said...
Inside APEX_WEB_SERVICE at the tail of every routine, we pretty much have a
for success:
sys.utl_http.end_response
for failure
exception when others then
sys.utl_http.end_request(...)
raise;
end;
so cleanup should be taking place . (I'm looking at APEX 22 and above here).
Can you give me a reproducible test case?