UTL_HTTP ORA-00018 error
- From: "smusgrove@xxxxxxxxx" <smusgrove@xxxxxxxxx>
- Date: 31 Mar 2006 07:28:34 -0800
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;
.
- Prev by Date: Re: how to know contents of blob column
- Next by Date: Procedure to run an application everyday.
- Previous by thread: Incremental load and indexes
- Next by thread: Procedure to run an application everyday.
- Index(es):
Relevant Pages
|
