Answer / ddrema

It's posible and mandatory if you use AUTONOMOUS
TRANSACTION in the TRIGGER.
like this:
CREATE OR REPLACE TRIGGER audit_sal
BEFORE UPDATE OF salary ON employees FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO emp_audit VALUES( :old.employee_id, SYSDATE,
:new.salary, :old.salary );
COMMIT;
END;
/

Answer / guest

no, it is not possible to use Transactional control
statements in Database Triggers

What is the use of FILE option in IMP command ?

1 Answers  

---

What are Stored Procedures and When would we Use Them?

1 Answers  

---

How do convert or display the date or time as string?

0 Answers  

---

How does distributed database work?

0 Answers  

---

Mention a query to calculate the even and odd records from a table

0 Answers  

---

---

What are new features postgre 9.1?

0 Answers  

---

how to retrive a data From database into the grid view..?

0 Answers   MCN Solutions,

---

What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

1 Answers   Sutherland,

---

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

0 Answers   eBay,

---

What is data sublanguage?

0 Answers  

---

Explain the difference between physical and logical data independence?

0 Answers  

---

Describe concurrency control.

0 Answers  

---