title: ORA-29270: too many open HTTP requests
body: <p>Can someone help me with this problem that occurs whenever you run a TRIGGER, but works in a normal PROCEDURE?</p>
  
  <p>TRIGGER:</p>
  
  <pre><code>create or replace
  procedure testeHTTP(search varchar2)
        IS
  
  Declare
       req   sys.utl_http.req;&lt;BR&gt;
    resp  sys.utl_http.resp;&lt;BR&gt;
   url varchar2(500);
  
  Begin
  
  
    url := 'http://www.google.com.br';
  
    dbms_output.put_line('abrindo');
    -- Abrindo a conexão e iniciando uma requisição
    req := sys.utl_http.begin_request(search);
  
    dbms_output.put_line('preparando');
    -- Preparandose para obter as respostas
    resp := sys.utl_http.get_response(req);
  
  
   dbms_output.put_line('finalizando response');
    -- Encerrando a comunicação request/response
    sys.utl_http.end_response(resp);
  
  
  Exception
    When Others Then
      dbms_output.put_line('excecao');
      dbms_output.put_line(sys.utl_http.GET_DETAILED_SQLERRM());
  
  End;
  </code></pre>