What is Pragma Autonomous transaction. It's Real time
Example
- 4 Answers
- 26450 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / neelbhotra
in Pragma Autonomous transaction
one(parents) transaction execute another transaction(child)
n the parent transaction suspend temporaly, wait till the
child transaction get complete (commited) n then parent is
resume.
ex.
it is used in interface pogram to hold the error datas in
error table & commited there, and from interface table the
inserted data is rollback.
| Is This Answer Correct ? | 21 Yes | 8 No |
Post New Answer View All Answers
Which oracle apps version you are very confident in?
q)what are the validations in sql*loader
Explain what are the tables of auto invoice?
In oracle application how do you debug or trace errors?
What are the different components you should consider while defining a responsibility in oracle apps?
What are do's and dont's of Interface?
What do you understand by soa and what are the benefits of using this architecture?
What are the benefits of using soa architecture?
What does appl_top directory contain?
What do you understand by concurrent programs?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
please send me forms, xml pulisher questions,answers
What do you understand by a set of books?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is a value set? List its various types.
