What is an autonomous transaction?

Autonomous transaction is a type of transaction used in a number of Oracle® database program programs. In the simplest sense, the autonomous transaction of transactions that occurs and completes as part of another transaction. During autonomous transactions, computer software is suspended by the processing of the original transaction, branched to obtain information or complete the process required by autonomous transaction. Once it gets the result for an autonomous transaction, it will raise exactly where it ended in processing the original transaction.

Autonomous transactions are usually used when the database operator wants to overcome a more complex transaction to its components. For example, if the database operator wants to create a list of all employees who earn more than $ 60,000 (USD) per year, and then wishes to divide this list only to employees under 30 years, using an autonomous transaction would be an autonomous transactionte to divide the request into two parts. First, the computer will collect a list of universitiesEch employees who earn $ 60,000. In the middle of this operation, the second part of the application for the completion of an autonomous transaction will be resolved and selects only those employees from the list of $ 60,000 or more who are also under 30 years of age.

One of the main advantages of autonomous transactions is that they provide greater simplicity when calling database operations. When splitting things into them, it may be easier to visualize each step in the process and mitigate the actual request coding process for the database operator. The second advantage of autonomous transactions is that they can be nested inside themselves; A qualified database operator can program a transaction that calls an autonomous transaction where autonomous transactions call any Number other autonomous transactions. This drastically improves Oracle Database Transaction Software Flexibility, which makes it easy to encode more complex transactions.

every tranceKCE, which occurs in the program, is monitored by the software itself for audit purposes. This allows individuals to check the transactions required from the database. Writing transactions in autonomous form can help simplify the audit procedure because it is much easier to understand a number of sequence simple transactions than a single complex command.