SQL & PL/SQL

I read almost all threads on this forum related to this error ORA-29270 but did not get answers for below questions

1. How to check active HTTP connection in oracle database?
2. How to interrupt HTTP connection if they exceed the limits?
3. How many HTTP connections are allowed per sessions while making APEX_WEB_SERVICE.MAKE_REQUEST?
4. I have tried following exceptions in the code but didn't work. because i am not sure how to handle below exception for this call APEX_WEB_SERVICE.MAKE_REQUEST.

• Exception

when utl_http.too_many_requests thenutl_http.end_response(l_result);

• This below was advised by Oracle to use but when i pass my as below then get the following error

        UTL_HTTP.DESTROY_REQUEST_CONTEXT(l_result);

ORA-06550: line 55, column 42:

PLS-00363: expression 'l_result' cannot be used as an assignment target

ORA-06550: line 55, column 9:

PL/SQL: Statement ignored

Following is the error and code.

ERROR

ORA-29273: HTTP request failed
ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 1745
ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 924
ORA-29270: too many open HTTP requests
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 902
ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 1640
ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 1767
ORA-06512: at "APEX_200100.WWV_FLOW_WEBSERVICES_API", line 196
ORA-06512: at line 19

DECLARE  
l_envelope CLOB;  
l_xml XMLTYPE;  
l_result VARCHAR2 (32767);  
p_login VARCHAR2 (100) := 'XXXX';  
p_pass     VARCHAR2 (100) := 'XXXX';  
BEGIN  
l_envelope :=  
'<?xml version="1.0" encoding="UTF-8"?>  
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.eClaimLink.ae/">  
<SOAP-ENV:Body>  
<ns1:GetNewTransactions>  
<ns1:login>'||p_login|| '</ns1:login>  
<ns1:pwd>'|| p_pass || '</ns1:pwd>  
</ns1:GetNewTransactions>  
</SOAP-ENV:Body>  
</SOAP-ENV:Envelope>  
';  
l_xml := APEX_WEB_SERVICE.make_request  
                                     (  
                                        p_url           => 'https://xxxx.ae/ValidateTransactions.asmx?WSDL  ',  
                                        p_action        => 'http://www.xxxx.ae/GetNewTransactions   ',  
                                        p_envelope      => l_envelope,  
                                        p_wallet_path   => 'file:D:\app\wallet',  
                                        p_wallet_pwd    => 'xxxx$xxx'  
                                     );  
l_result := APEX_WEB_SERVICE.parse_xml (       p_xml     => l_xml  
                                             , p_xpath   => '//text()'  
                                             , p_ns      =>  'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   
                                                              xmlns:xsd="http://www.w3.org/2001/XMLSchema"  
                                                              xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"'  
                                        );  
DBMS_OUTPUT.put_line ('l_xml=' || l_xml.getClobVal ());  
DBMS_OUTPUT.put_line ('l_result =' || l_result);  
END;  

***Moderator action (Timo): removed private information.***