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
In hierarchical structure of a database? we have write query from where we should start?
What is a flexfield? List out its types.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
tell my any difficult situtation you solved in your experience in your company?
Do you know where we can check the status of po?
What are the different components of soa suite?
Can you differentiate between mediator and osb?
How to move the one file from one instance to another instance? And your scripts also?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is oracle soa suite?
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.
do you know is it possible to run the interface without using oracle apps?
How can you achieve loose coupling in soa framework?
List the types of flexfield?
How can we import the data into a database using sql * loader?