Home » SQL & PL/SQL » SQL & PL/SQL » Independent autonomous transactions
Independent autonomous transactions [message #228564] Tue, 03 April 2007 06:43 Go to next message
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 #228578 is a reply to message #228564] Tue, 03 April 2007 07:25 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use DBMS_ALERT to send an asynchronous signal to a process running in another session.
Re: Independent autonomous transactions [message #228624 is a reply to message #228578] Tue, 03 April 2007 09:03 Go to previous messageGo to next message
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.
Re: Independent autonomous transactions [message #228629 is a reply to message #228624] Tue, 03 April 2007 09:24 Go to previous message
sukhadukkham
Messages: 3
Registered: September 2006
Location: Switzerland
Junior Member
you may use the the advanced queuing feature for this
Previous Topic: temporary tables problem
Next Topic: VB6 and oracle connection
Goto Forum:
  


Current Time: Wed Dec 07 14:44:01 CST 2016

Total time taken to generate the page: 0.10953 seconds