Home » SQL & PL/SQL » SQL & PL/SQL » Start autonomous transaction without suspending Main transaction (Oracle 9.2.0.7)
Start autonomous transaction without suspending Main transaction [message #392907] Thu, 19 March 2009 11:12 Go to next message
sky_lt
Messages: 28
Registered: February 2009
Location: vilnius
Junior Member
Hi all,

Is it possible to start autonomous transaction without suspending main transaction?

Are there any other ways to execute different pl/sql blocks
in different transactions or sessions without suspending the main
transaction?

Thanks

Sky_lt
Re: Start autonomous transaction without suspending Main transaction [message #392909 is a reply to message #392907] Thu, 19 March 2009 11:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
DBMS_JOB might work for you.
Re: Start autonomous transaction without suspending Main transaction [message #392911 is a reply to message #392907] Thu, 19 March 2009 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Is it possible to start autonomous transaction without suspending main transaction?

No.

Quote:
Are there any other ways to execute different pl/sql blocks
in different transactions or sessions without suspending the main
transaction?

Spawn a procedure or PL/SQL block using dnms_job.

Regards
Michel
Re: Start autonomous transaction without suspending Main transaction [message #393101 is a reply to message #392911] Fri, 20 March 2009 05:48 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
Is it possible to start autonomous transaction without suspending main transaction?


What exactly do you mean?
If you tell us what you're trying to achieve, we can be much more help than by answering obscure questions.

It's true for pretty much every problem that Autonomous Transations are not the solution you are looking for.
Previous Topic: Table hierarchy
Next Topic: Multiple records in one row
Goto Forum:
  


Current Time: Thu Dec 05 01:43:48 CST 2024