Re: Launching a stored procedure asynchronously

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: 2000/06/22
Message-ID: <8iu0bt$lef$1@news.inet.tele.dk>#1/1

You can submit a stored procedure to be run via the internal job scheduler in Oracle, have a look at DBMS_JOB.

HTH. Finn

<jay_at_allardworks.com> wrote in message news:8ittcp$lvi$1_at_nnrp1.deja.com...
> Hello
>
> I'm not sure if this is going to the best forum or not, but thought I'd
> give it a shot.
>
> An ASP page is going to instantiate a DLL. I'd like that DLL to connect
> to an oracle database, launch a stored procedure, and then return
> control to the ASP. The stored procedure may take several minutes (or
> more) to run, so I'd like it to run asynchronously.
>
> One way to do this is to have the DLL launch an EXE which does the
> work. However, if there's a way to do it via oracle, I'd rather do it
> that way.
>
> Any suggestions?
>
> Thanks
>
> Jay
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 22 2000 - 00:00:00 CDT