Answer / prasad reddy

Yes ,You can Commit inside the trigger.

But for this you have to make this trigger transaction to be
a Independent transaction from its parent transaction, You
can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION
allow you to build the Indepadent(child) Transaction,started
by another

Cheers
-Prasad

Answer / 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.

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

what is difference between API and Interface?

2 Answers   Infogain,

---

How to register a form and stored procedure in oracle apps

2 Answers   Mastek, TCS,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

where u do setup of operating unit?

1 Answers   TCS,

---

how many layout sections are tehre in layout editor?

1 Answers  

---

Form development process?

1 Answers  

---

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

What are the tables in GL?

3 Answers   Convergys,

---

what is aim methodolozy

1 Answers  

---