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

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

868


How many schemas we have? how many you have used?

1813


What is the concept of soa governance?

1003


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

873


Can you differentiate between mediator and osb?

871


what is the differences between internal requisition and internal sales order?

2395


What is a flexfield? List out its types.

909


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2359


What does appl_top directory contain?

863


What do you understand by a set of books?

845


Which oracle apps version you are very confident in?

950


tell me the scenarios of the independent in reports

2261


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2828


is it possible to run the interface without using oracle apps?

1723


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

963