Database Networking (MOSC)

MOSC Banner

utl_http and connect timeout

edited Feb 19, 2009 2:24AM in Database Networking (MOSC) 2 commentsAnswered
hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center