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


Please Help Members By Posting Answers For Below Questions

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1993


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2848


Do you know what is applysys in oracle application database schema, what is apps?

981


Can you explain the difference between architecture followed in 10g & 11g?

878


What is a value set? List its various types.

879


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1877


what are the balancing segments in AR?

1874


In sequence i want to 11 and 15th values how we will write?

1853


How can you achieve loose coupling in soa framework?

1020


Do you know what are user profiles in apps. Any examples you can give?

895


Tell me how to find the custom directory in front end?

895


what are the different transaction clauses in AR?

1855


List the types of flexfield?

829


How to move the one file from one instance to another instance? And your scripts also?

884


Which oracle apps version you are very confident in?

965