Hello,

I am trying to write a PL/SQL procedure that will loop through a list
of URLs and determine whether or not they actually exist. For each
URL, I'm performing the following sequence of procedure/function calls:
UTL_HTTP.BEGIN_REQUEST, UTL_HTTP.GET_RESPONSE, UTL_HTTP.END_RESPONSE.
After about 675 iterations of the loop, I get the "ORA-00018: maximum
number of sessions exceeded" exception. I'm not using persistent
connection support. The basic loop follows. I would appreciate any
help that you can provide.

Thanks,

Steve.

UTL_HTTP.SET_DETAILED_EXCP_SUPPORT (TRUE);
UTL_HTTP.SET_PERSISTENT_CONN_SUPPORT (FALSE, 1);

FOR cImages IN c_add_files LOOP
-- See if the image URL is valid.
request := UTL_HTTP.BEGIN_REQUEST (URL =>
cImages.IAF_LOCATION,
METHOD => 'GET');
UTL_HTTP.SET_HEADER (R => request,
NAME => 'User-Agent',
VALUE => 'Mozilla/4.0');
response := UTL_HTTP.GET_RESPONSE (r => request);

IF response.STATUS_CODE <> UTL_HTTP.HTTP_OK THEN
...
END IF;
UTL_HTTP.END_RESPONSE (r => response);
END LOOP;