Jun 2008: Do you know autonomous transaction?

HOME

PRODUCTS

COMMUNITY

EXPERTS

BLOGS

KNOWLEDGE

WORLD

EVENTS

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?

Follow Toad


		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