can u explain which situation automonus transaction is used
Answers were Sorted based on User's Feedback
Answer / jyotiprosad roy
1 Commit in Trigger
2 Avoid Table Mutation Trigger
3 Call of function in select stmt with DML
4 Two program units ( caller and called) with two states of
commit nature
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar
Autonomous transactions are independent transactions within parent transaction.
At the time of insertion and updation of records into table which has to pass validation then autonomous transactions used.
Is This Answer Correct ? | 0 Yes | 0 No |
What are different execution methods of executabls?
Can functions be overloaded ?
What are basic steps for AIM?
In what situation u create the BPA.
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
what is multi org structure?
we have 4 managers if one person logon the system automatically displays his siganature and name how?
what is mutating table and mutating error and how to solve that?
what is the difference between procedure and function
What is request group
what is the difference between request group and request security group in oracle apps?
Matrix Report: Simple, Group above, Nested