Re: Errors using UTL_HTTP

Kurt Laugesen wrote:

> I have made a procedure that accesses som xml from a URL using the
> utl_http package.
>
> When I run this from a sql*plus prompt it works fine, even if I have
> several sessions in parallel doing maybe 50 lookups each in a loop.
> However - when it is called from a webapplication we frequently (but
> not allways) end up with the error
> ORA-29270 too many open HTTP requests
> Cause: Too many HTTP requests were opened.
> Action: End some HTTP requests and retry the HTTP request.
> (I love those error messages :-)
>
> My procedure basically does this:
> Compose the URL (with parameters)
> do begin_request
> handle the incoming lines
> do end_request.
>
> Is there a limit to the number of concurrent sessions, that can access
> utl_http?
> Or am I overlooking something else?
>
> TIA
> Kurt Laugesen

Can you post or zip up and send the actual code? It would help to understand what you are doing.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)