多次调用UTL_HTTP包提示ORA-29270:too many open HTTP requests解决方法

多次调用UTL_HTTP包提示ORA-29270:too many open HTTP requests解决方法

多次调用UTL_HTTP包提示ORA-29270: too many open HTTP requests

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1367

ORA-29270: too many open HTTP requests

解决方法

BEGIN

  l_http_request := utl_http.begin_request (p_url, 'POST');

  BEGIN

    -- build the request by using utl_http.set_header() and utl_http.write_text()

    -- ...

  

    -- process the request and get the response:

    l_http_response := utl_http.get_response (l_http_request);

  EXCEPTION

    WHEN OTHERS THEN

     utl_http.end_request(l_http_request);

     RAISE;

  END;

  BEGIN

    LOOP

      -- read the response using utl_http.read_line()

      -- ...

    END LOOP;

    -- Complete the request and response, and close the network connection

   utl_http.end_response(l_http_response);

  EXCEPTION

    WHEN utl_http.end_of_body THEN

     utl_http.end_response(l_http_response);

    WHEN OTHERS THEN

     utl_http.end_response(l_http_response);

     RAISE;

  END;

END;

-- 刘轶鹤