ORA-29270:打开的HTTP请求过多 [英] ORA-29270: too many open HTTP requests

问题描述

有人可以帮我解决这个问题，该问题在您运行TRIGGER时会发生，但可以正常运行吗?

Can someone help me with this problem that occurs whenever you run a TRIGGER, but works in a normal PROCEDURE?

触发:

create or replace
procedure testeHTTP(search varchar2)
      IS

Declare
     req   sys.utl_http.req;<BR>
  resp  sys.utl_http.resp;<BR>
 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;

推荐答案

关闭用户会话，然后解决此问题.

close your user session and then the problem is fixed.

内部有5个http请求的限制.

Internal there is a limit from 5 http requests.

可能缺少一个问题:utl_http.end_response

或应用程序中的异常，而不是resp对象的结束.

or an exception in the app and not a close from the resp object.

像这样修改代码:

EXCEPTION
  WHEN UTL_HTTP.TOO_MANY_REQUESTS THEN
  UTL_HTTP.END_RESPONSE(resp); 

这篇关于ORA-29270:打开的HTTP请求过多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！