6 Replies Latest reply on Jun 17, 2019 8:42 AM by 3249646

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

    3249646

      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