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 database write application of database?

0 Answers  

---

What is pdo database?

0 Answers  

---

Define cursor and its types.

0 Answers  

---

What is cluster table or non_cluster table?

1 Answers  

---

Does netlib support windows 95?

0 Answers  

---

Do we consider null values the same as that of blank space or zero?

0 Answers  

---

What are the differences between drop, truncate and delete commands?

0 Answers  

---

Explain 3nf?

0 Answers  

---

If I use netlib, will I find many other users to network with?

0 Answers  

---

What is a database in business?

0 Answers  

---

Who is the founder of database?

0 Answers  

---

How to detect the server version?

0 Answers  

---