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
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
where to define interorganization transaction charges and what are the different options?
What is instead of trigger in where we will use?
What do you understand by concurrent programs?
What does appl_top directory contain?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Explain what are the tables of auto invoice?
do you know is it possible to run the interface without using oracle apps?
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.
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?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What is a flexfield? List out its types.
Can you define an erp system?
how do you describe O2C along with tables