can we use commit in trigger? If yes how?
- 2 Answers
- 17712 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
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How can we import the data into a database using sql * loader?
Can u give the Documentation of Custom.pll in oracle apps
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What do you understand by soa and what are the benefits of using this architecture?
Do you know what is applysys in oracle application database schema, what is apps?
what is the difference between request group and request security in oracle apps?
testing tools?
Explain what are the tables of auto invoice?
List the types of flexfield?
where to define interorganization transaction charges and what are the different options?
q)what are the validations in sql*loader
What are the different components you should consider while defining a responsibility in oracle apps?
What does appl_top directory contain?
Tell me where we find the status of order information?
