Hello,
I'm using Oracle 11g, and have this code:
….
begin
request_context := utl_http.create_request_context (
wallet_path => 'file:-------------------------------',
wallet_password => NULL
);
req := utl_http.begin_request(url => urlWhat, request_context => request_context);
res := utl_http.get_response(req);
utl_http.read_text(res, resText);
utl_http.end_response(res);
resXML:= XMLType.createXML(resText);
doc := DBMS_XMLDOM.newDOMDocument(resXML);
...
exception
when utl_http.end_of_body then
utl_http.end_response(res);
when utl_http.too_many_requests then
utl_http.end_response(res);
….
The package works well, but after 5 requests I get the following error, even though I use utl_http.end_response:
ORA-29270: too many open HTTP requests
ORA-06512: ..., line 50
ORA-06512: ... line 1
29270. 00000 - "too many open HTTP requests"
*Cause: Too many HTTP requests were opened.
*Action: End some HTTP requests and retry the HTTP request.
Can you help me? Whan I'm doing wrong?
Thanks in advance and best regards,
Alida