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?

1806


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

1657


Can you define an erp system?

682


tell me the scenarios of the independent in reports

2110


how to print multi lay outs,muti currency,muti language in xml publisher

10758






What is count(*) from po_vendors(any table)?

645


testing tools?

1758


Can you differentiate between mediator and osb?

629


what is the difference between request group and request security in oracle apps?

5057


List the types of flexfield?

605


Tell me how to debug the report?

643


Tell me where we find the status of order information?

669


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

1522


Are you familiar with internet architecture of oracle apps 11i?

636


How can we import the data into a database using sql * loader?

684