Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> UTL_HTTP ORA-00018 error

UTL_HTTP ORA-00018 error

From: <smusgrove_at_ircwv.com>
Date: 31 Mar 2006 07:28:34 -0800
Message-ID: <1143818914.593102.60940@u72g2000cwu.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US