can we use commit in trigger? If yes how?
Answer Posted / srinivasa reddy k
Generally we cannot use commit in triggers.
But it is possible to use commit in triggers by
mentioning "pragma autonomous_transaction;" in the
declarative section of the trigger.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is instead of trigger in where we will use?
How to create a purchase order without a requisition?
In support project one ticket alloted which steps follows manualy tell me ?
List the types of flexfield?
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.
What is sca and how is it useful?
In hierarchical structure of a database? we have write query from where we should start?
List the various types of value set.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What is the concept of soa governance?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How many schemas we have? how many you have used?
Tell me how to find the custom directory in front end?
where to define interorganization transaction charges and what are the different options?