Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29270: too many open HTTP requests even though I'm using utl_http.end_response

3249646Jun 13 2019 — edited Jun 17 2019

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

This post has been answered by 3249646 on Jun 17 2019
Jump to Answer
Comments
Post Details
Added on Jun 13 2019
6 comments
23,945 views