SQL & PL/SQL

Hi,

I am trying to work with UTL_HTTP to send some soap requests and get responses to and from a web server.

When the soap request / response was fairly small, the API (which in turn uses utl_http) runs fine. But, when I send in a fairly big file, it is erroring out with a couple of errrors:

In the invoke get_response procedure ORA-29276: transfer timeout
Detail sqlcode and sqlerrm in soap http invoke: -29276 : ORA-29276: transfer
timeout

ORA-06512: at "SYS.UTL_HTTP", line 1231
ORA-29276: transfer timeout


ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1231
ORA-29276: transfer timeout

And then, because of the transfer timeout, I increased the timeout to 10 minutes from 1 minute. Now, I am getting this error:

SQL> begin
  2  utl_http.set_transfer_timeout(600);
  3  --my_program;
  4  end;
  5  /
In the invoke get_response procedure ORA-12547: TNS:lost contact
Detail sqlerrm in soap http invoke: ORA-12547: TNS:lost contact Transfer timeout
value is: 600
Error is in putconvertlinedata invoke function: ORA-29273: HTTP request
failed
ORA-06512: at "SYS.UTL_HTTP", line 1231
ORA-12547: TNS:lost contact
begin
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1231
ORA-12547: TNS:lost contact

Tried googling it, but, couldn't find this exact situation anywhere.


Thank you,
Rahul.