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 the Lookup's and what is the use of lookup's?

3 Answers   TCS,

---

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

Registering parametric report?

1 Answers  

---

---

how to enable Zoom function and steps?

1 Answers   Patni,

---

where do u specify in org_id?

2 Answers  

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

Exception Handilings?

1 Answers  

---

LOCKS?

1 Answers  

---

in procedure how to return a value

2 Answers   Wipro,

---