what is "PRAGMA AUTONOMOUS_TRANSACTION" mean

[mike2000]

I read this on technet but I got confused and don't know what they mean. could someone give me a clear explanation????

thanks

[stecal]

http://tahiti.oracle.com

The AUTONOMOUS_TRANSACTION pragma instructs the PL/SQL compiler to mark a routine as autonomous (independent). An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction. For more information, see "Doing Independent Units of Work with Autonomous Transactions".

??

[jmodic]

RTFM