The displayed problem is the fact that there are many open connections, from what I studied Oracle automatically closes your connections, but in my code I am Using the UTL_HTTP.SET_PERSISTENT_CONN_SUPPORT (HTTP_REQ, TRUE); where it maintains the connection, so I can send several data within a loop without having to open a connection each time, this is to send large amounts of data, now the doubt how to close the connection? Below is the access code below.
Thanks!
http_req := utl_http.begin_request(WW_URL, 'POST',utl_http.HTTP_VERSION_1_1);
utl_http.set_persistent_conn_support(http_req,true);
utl_http.set_body_charset(http_req, 'UTF-8');
UTL_HTTP.set_authentication(http_req, 'SA', 'GN5', 'Basic', TRUE );
utl_http.set_header(http_req, 'Content-Type', 'text/xml');
utl_http.set_header(http_req, 'Content-Length', length(WW_ENV));
utl_http.set_header(http_req, 'SOAPAction', 'setCliente');
utl_http.write_text(http_req,WW_ENV);
http_resp := utl_http.get_response(http_req);
IF (http_resp.status_code =utl_http.HTTP_OK ) THEN
utl_http.read_text(http_resp, WW_ENV_RESP);
utl_http.end_response(http_resp);
WW_RESP := xmltype.createxml(WW_ENV_RESP);