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
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
is it possible to run the interface without using oracle apps?
Can we create tables in apps schema?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Is soa a part of oracle fusion middleware?
List the various types of value set.
What is oracle soa suite?
Tell me where we find the status of order information?
Do you know what are user profiles in apps. Any examples you can give?
testing tools?
do you know is it possible to run the interface without using oracle apps?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What is instead of trigger in where we will use?
How can we import the data into a database using sql * loader?
Can you explain the difference between architecture followed in 10g & 11g?