Re: Run Proc Async

Hello Mark,
  All the methods involve starting another transaction. This can make recovery / rollback a problem. With this in mind:  As other people have suggested: DBMS_JOB, or a listener at the end of DBMS_PIPE or the HOST command from SQL*Plus are the obvious ones which come to mind. They all have advantages and dis-advantages and all work fine.

I cannot think of a way of doing it in the current transaction.

graham (aka grumpy)

mwagoner_at_iac.net (Mark Wagoner) wrote...

| 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)
|

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost. Received on Thu Jun 05 1997 - 00:00:00 CDT