| Independent autonomous transactions [message #228564] |
Tue, 03 April 2007 06:43  |
ziggy25
Messages: 206
Registered: July 2005
|
Senior Member |
|
|
Other than using DBMS_JOB, is there another way to run independent of the main transaction? I would like the main transaction to continue processing without waiting for the subprogram to finish.
Thanks
|
|
|
|
|
|
| Re: Independent autonomous transactions [message #228624 is a reply to message #228578] |
Tue, 03 April 2007 09:03  |
ziggy25
Messages: 206
Registered: July 2005
|
Senior Member |
|
|
| JRowbottom wrote on Tue, 03 April 2007 07:25 | You can use DBMS_ALERT to send an asynchronous signal to a process running in another session.
|
How would that work? What i would like to do is be able to execute another subprogram/stored procedure and let it run in its own space independently. The stored procedure will take longer to complete so i dont want the calling procedure to wait for it to finish.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
