Answer Posted / sudhir

by default Trigger doesnt allow a commit;

however we can create a stored procedure which will only do
commit.

create or replace procedure to_commit_trigger
begin
commit();

end to_commit_trigger


now execute this stored procedure to_commit_trigger inside a
trigger to perform a commit. However it will cause serious
performance issues.

Is the After report trigger fired if the report execution fails ?

2876

---

What are triggers in oracle?

976

---

How to assign values to data fields in record variables?

973

---

How can I create database in oracle?

958

---

Explain compound trigger in oracle?

985

---

How to pass a parameter to a cursor in oracle?

1102

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2899

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1056

---

What is an oracle transaction?

1051

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1020

---

Difference between open_form and call_form in oracle.

1092

---

How do I connect to oracle database?

1023

---

How to use group functions in the select clause using oracle?

1022

---

How to start a specific oracle instance?

989

---

How to loop through data rows in the implicit cursor?

1014

---