Autonomous Transaction in Oracle Options

codeling 1236 - 5298
@2020-02-06 09:43:49

You cannot apply this pragma to an entire package, but you can apply it to each subprogram in a package.

Unlike an ordinary trigger, an autonomous trigger can contain transaction control statements, such as COMMIT and ROLLBACK, and can issue DDL statements (such as CREATE and DROP) through the EXECUTE IMMEDIATE statement.


codeling 1236 - 5298
@2020-02-06 10:09:53

If you try to exit an active autonomous transaction without committing or rolling back, the database raises an exception. If the exception goes unhandled, or if the transaction ends because of some other unhandled exception, the transaction is rolled back.

Users browsing this topic
Guest