Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Utl_http request and response issue

JiminyAug 14 2013 — edited Aug 15 2013

Hi,

I am using Database Version 10g Release 10.2.0.3.0

I have a utl_http.begin_request the request is connecting to a server using a URL with parameters and returning a cookie value during an authentication process.

If the server is unavailable or the response is slow I am looking to stop the request and prevent a long wait time.

I have investigated the utl_http.set_transfer_timeout procedure which sets the default time out value for all future HTTP requests that the UTL_HTTP package should attempt while reading the HTTP response from the Web server or proxy server.  However this is failing to limit my wait time, i think this is due to the procedure reading the HTTP response from the Web server or proxy server and not waiting for a response.

Is there a way to set a wait time for the utl.http package or a way of simply timing out after a declared time limit?

Any ideas would be appreciated.

Thanks,

JIM

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2013
Added on Aug 14 2013
5 comments
3,934 views