What is Pragma Autonomous transaction. It's Real time
Example

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


Please Help Members By Posting Answers For Below Questions

How do you register report in oracle apps?

626


List the types of flexfield?

605


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1684


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2126


What do you understand by a set of books?

643






testing tools?

1750


Can you explain the difference between architecture followed in 10g & 11g?

654


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2591


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1565


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1647


what are the balancing segments in AR?

1647


What is sca and how is it useful?

656


is it possible to run the interface without using oracle apps?

1516


Can u give the Documentation of Custom.pll in oracle apps

2993


What are do's and dont's of Interface?

1903