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 describe O2C along with tables
Which oracle apps version you are very confident in?
Tell me where we find the status of order information?
What are the benefits of using soa architecture?
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?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by soa and what are the benefits of using this architecture?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
tell my any difficult situtation you solved in your experience in your company?
What is count(*) from po_vendors(any table)?
What is instead of trigger in where we will use?
Do you know what is applysys in oracle application database schema, what is apps?
what are the different transaction clauses in AR?
Tell me how to find the custom directory in front end?