What is autonomous transaction? - oracle

What is autonomous transaction?

Autonomous transactions have the ability to leave the context of calling transaction, then perform an independent transaction, and again return to the calling transaction without affecting its state. It has no link to the calling transaction, thus allowing only committed data to be shared between the 2 transactions.

Following types can be defined as autonomous transactions:

- Stored procedures
- Functions
- Local procedures and functions defined within a PL/SQL block
- Packaged Procedures and functions
- Type methods
- Top level anonymous blocks
How to create LOV in Oracle forms? - oracle
How to create LOV in Oracle forms? - List of Values(LOV) are used either when a selected list is too long and hence would not be appropriate for a drop down, but needs a search form to select the value...
Which sql command to be used to get a print out from oracle?
Sql command to print out from oracle - PRINT: ...
What is sql*loader parameters and where do we use it? - oracle
sql*loader parameters - SQL Loader is used for the following: • Load data across a network. • Load data from multiple data files during a single load session...
Post your comment