Jun 2008: Do you know autonomous transaction?

Home

Products

Community

Experts

Knowledge

Downloads

Hello, you are not logged in. Login or sign up

Experts >> Steven Feuerstein's PL/SQL Obsession >> Puzzles and Quizzes >> Jun 2008: Do you know autonomous transaction?


		Toad World Puzzler - June 2008

Oracle introduced the autonomous transaction feature way back in Oracle8i. For which of the following scenarios would this feature definitely NOT be helpful?

A. A mutating table error in a trigger in which I am querying data from the table from which the trigger is fired.

B. I want to log an error so that when I rollback my business transaction, I do not lose my error log entry.

C. Each user of my application needs to work autonomously with the tables of the application. In other words, if USER1 makes a change to table ABC, then I want to make sure that USER2 can also work on that table at the same time (but not necessarily the same rows).

D. I need to keep an audit trail of every row that is retrieved by a set of queries in my application.

Submit