Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Run Proc Async

Run Proc Async

From: Mark Wagoner <mwagoner_at_iac.net>
Date: 1997/06/05
Message-ID: <5n6ch1$2l5$1@ocoee.iac.net>#1/1

Is it possible to run a stored procedure asynchronously? I need to have one procedure (or external app) start a stored procedure but regain control immediately. I need the second procedure to continue running in the background.

If I use EXECUTE from SQL*Plus, I have to wait until the procedure ends before I can continue. Same thing if I call the procedure from a PL/SQL block. Does anyone know a way around this?

Thanks

--
Mark Wagoner
mwagoner_at_medplus.com (work)
mwagoner_at_iac.net     (life)
Received on Thu Jun 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US