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 is mutating table and mutating error and how to solve that?

3 Answers  

---

how can we get odd numbered pages in output of a report

2 Answers   Infosys,

---

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 Answers  

---

why do we go for oracle apps technical other than sap and other packages?

2 Answers  

---

where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,

---

Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,

---

What is oracle soa suite and what are its different components?

0 Answers  

---

what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,

---

what is global tempory table?

1 Answers   BirlaSoft,

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,

---

what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,

---