Memory/Connection Leak in UTL_HTTP?
643700Jun 6 2008 — edited Jun 9 2008Hello,
After calling the UTL_HTTP.BEGIN_REQUEST function for a significant number of times (20,000+ transactions), the session terminates with an "END OF FILE ON COMMUNICATIONS CHANNEL". Subsequent attempts to use this function result in this error as well (or a similar process dump). Furthermore, it seems that this eventually affects the Oracle listener such that the database instance needs to be restarted. I have provided a test script below, which invokes the error in the Oracle version that I am using (10.2.0.3). Any help would be much appreciated.
DECLARE
http_req utl_http.req;
http_resp utl_http.resp;
BEGIN
WHILE TRUE
LOOP
http_req := utl_http.begin_request('http://<<YOUR_LOCAL_TEST_WEB_SERVER>>', 'POST', utl_http.HTTP_VERSION_1_1);
http_resp := utl_http.get_response(http_req);
utl_http.get_response(http_resp);
END LOOP;
END;