Wednesday, October 12, 2011

What is 'pragma autonomous_transaction' in Oracle?

A transaction that can be committed independently from the parent transaction.
i.e. its commit will not affect the previous unsaved transactions.

Ref:
http://docs.oracle.com/cd/B14117_01/appdev.101/b10807/13_elems002.htm
http://www.geekinterview.com/question_details/36513

No comments: