Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is autonomouse transaction?

Answers were Sorted based on User's Feedback



what is autonomouse transaction?..

Answer / p.rajasekar

Autonomous transactions are started by a parent, or main,
transaction but operate
independently of the parent for transaction control. If a
commit or rollback is used
in the autonomous or main transaction, or if a failure
occurs for any reason, it does
not impact the other transaction.
Our favorite use of this feature is for logging application
events. If the need is to
log activity, regardless of the outcome, but the logging
success or failure should not
impact the application, autonomous transactions are the
perfect solution.
To create an autonomous transaction, use a pragma called
AUTONOMOUS_TRANSACTION. The pragma is placed in the
declaration section of the block.

Is This Answer Correct ?    16 Yes 0 No

what is autonomouse transaction?..

Answer / rasmita basantia

its mainly used in that schenario where u are interested to
perform independent transaction.

Is This Answer Correct ?    1 Yes 0 No

what is autonomouse transaction?..

Answer / singh

eg: We can take a normal bank transaction. Each transaction
has two part one debit and other credit and if any one part
fails the whole transanction fails.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,


What are the advantages of sql? Explain

0 Answers  


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  


What is referential integrity ?

3 Answers   BirlaSoft,


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  


Can a commit statement be executed as part of a trigger?

0 Answers  


Is primary key an index?

0 Answers  


What is the difference between partitioning and sharding?

0 Answers  


What is the use of sql trace?

0 Answers  


What is rowtype?

0 Answers  


How will we see framework of a table?

2 Answers   Accenture,


What is foreign key and example?

0 Answers  


Categories