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
How do you register report in oracle apps?
List the types of flexfield?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What do you understand by a set of books?
testing tools?
Can you explain the difference between architecture followed in 10g & 11g?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
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
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
what are the balancing segments in AR?
What is sca and how is it useful?
is it possible to run the interface without using oracle apps?
Can u give the Documentation of Custom.pll in oracle apps
What are do's and dont's of Interface?