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.

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

---

wht is difference between is and as varibales,while declaring procedure which is better?

3 Answers   Wipro,

---

what r the objects u have to do in u experiance

1 Answers  

---

Difference between triggers and procedures?

2 Answers  

---

explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,

---

What are basic steps for AIM?

2 Answers  

---

do you know is it possible to run the interface without using oracle apps?

0 Answers  

---

Can we run a package with out specification?If yes how?

4 Answers  

---

what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,

---

How You Will display the key flexifields in your report

3 Answers   TCS,

---

What is Place holder Columns?

3 Answers  

---

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,

---