utl_http and connect timeout
at our application we use utl_http package to post and retrieve data from web services. but sometimes remote service could be unreachable and we get ORA-12535: TNS:operation timed out.
to get the timeout error oracle tries for approximately 3,40 - 3,50 minutes. we first use UTL_HTTP.SET_TRANSFER_TIMEOUT(60); to reduce timeout value.
but it did not worked, because UTL_HTTP.SET_TRANSFER_TIMEOUT method only considers data transfer timeouts, not conncetion timeouts.
at note:760664.1 it says that TCP.CONNECT_TIMEOUT parameter at sqlnet.ora is used for connection timeouts. so we set it, but it is not working either.