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.

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers  

---

what is multi org structure?

3 Answers   Covansys, TCS,

---

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

2 Answers   TCS,

---

What is instead of trigger in where we will use?

0 Answers  

---

what are the types of interfacing?

3 Answers   TCS,

---

Attribute data types?

2 Answers  

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

what is item status? name the related table.

1 Answers   Scan Steel,

---

oracle apps architecture

1 Answers   TCS,

---

What is responsibility?

5 Answers  

---

Stored procedure?

4 Answers  

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---