Re: UTL_HTTP question

From: Rauf Sarwar <rsarwar_at_ifsna.com>
Date: 12 Jun 2002 13:08:42 -0700
Message-ID: <c2d690f2.0206121208.32961f14@posting.google.com>

tana_at_acedsl.com (Tana) wrote in message news:<4294f74d.0206120646.11b5a374_at_posting.google.com>...
> HI,
>
> I use utl_http.request() function to cal some ASP script on a web
> server.
> The system than waits for the response and that's what I have a
> problem with.
>
> Is there any way to simply send request and let SP keep running(not
> wait for the response from other side).
>
> Should I use different ORACLE package/function or some any other way
> to do this?
>
> thanks very much
> Tana

Pass your request to a background job/process. You have to break the process in more then one processes so that you can submit a request and RETURN...then other process picks up your request to complete it...something like this,
1) Create a table to hold all your http requests with some sort of "Posted" flag.
2) Let your background job wake up every x number of minutes to query for posted jobs.
3) Background job completes the request...changes flag to something like "Done".

Check DBMS_JOB package to create new jobs. Received on Wed Jun 12 2002 - 15:08:42 CDT