can we use commit in trigger? If yes how?
Answer Posted / prasad reddy
Yes ,You can Commit inside the trigger.
But for this you have to make this trigger transaction to be
a Independent transaction from its parent transaction, You
can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION
allow you to build the Indepadent(child) Transaction,started
by another
Cheers
-Prasad
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What do you understand by soa and what are the benefits of using this architecture?
q)what are the validations in sql*loader
Can you define an erp system?
What is oracle soa suite and what are its different components?
In sequence i want to 11 and 15th values how we will write?
How many schemas we have? how many you have used?
where to define interorganization transaction charges and what are the different options?
Tell me how to debug the report?
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.
how to print multi lay outs,muti currency,muti language in xml publisher
is it possible to run the interface without using oracle apps?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Tell me how to find the custom directory in front end?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Tell me where we find the status of order information?