Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> UTL_HTTP ORA-00018 error
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
IF response.STATUS_CODE <> UTL_HTTP.HTTP_OK THEN ... END IF; UTL_HTTP.END_RESPONSE (r => response);END LOOP; Received on Fri Mar 31 2006 - 09:28:34 CST