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.

why do we validate the records while developing interface?

3 Answers   TCS,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

What are basic steps for AIM?

2 Answers  

---

Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

What is the most critical part which you had faced in your project ?

1 Answers   LG, Satyam, Tech Mahindra,

---

what are the important table names in purchasing?

3 Answers   TCS,

---

LOCKS?

1 Answers  

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

How does accounting occured in Expense Reporting?

1 Answers   Sapient,

---

what is back order in OM

4 Answers   IBM, Oracle,

---

what are the sql attributes?

2 Answers  

---