can we use commit in trigger? If yes how?
- 2 Answers
- 17975 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
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
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Do you know what is applysys in oracle application database schema, what is apps?
Can you explain the difference between architecture followed in 10g & 11g?
What is a value set? List its various types.
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
what are the balancing segments in AR?
In sequence i want to 11 and 15th values how we will write?
How can you achieve loose coupling in soa framework?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to find the custom directory in front end?
what are the different transaction clauses in AR?
List the types of flexfield?
How to move the one file from one instance to another instance? And your scripts also?
Which oracle apps version you are very confident in?
