I read this on technet but I got confused and don't know what they mean. could someone give me a clear explanation????
thanks
Printable View
I read this on technet but I got confused and don't know what they mean. could someone give me a clear explanation????
thanks
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".
??
RTFM