can we use commit in trigger? If yes how?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What repots or concurrent program run to transfer data from Inventory to GL.
do i need to declare bind parameter before using in the query?
Can we run a package with out specification?If yes how?
Do you know what are user profiles in apps. Any examples you can give?
In support project one ticket alloted which steps follows manualy tell me ?
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
in one report using two layout models.if yes how to do
How many typres of Purchase order and what are those.
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
when we run payment batch what are the 3 concurrent programs?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?