Answer Posted / santosh kumar

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. Shold be declare in DECLARE section of any subprogram.

Used to make Modular and Resuable Blocks. if you need the example then ask to me.

CREATE OR REPLACE TRIGGER TRIG_ARG
AFTER INSERT ON TAB1
DECLARE
PRAGMA AUTONOMOUNS_TRNASACTION
BEGIN
INSERT INTO LOG VALUES(SYSDATE,'INSERT ON TAB1');
COMMIT;
END;
/

OR

CREATE OR REPLACE TRIGGER t_trigger
AFTER INSERT ON t1 FOR EACH ROW

DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
i PLS_INTEGER;
BEGIN
SELECT COUNT(*)
INTO i
FROM t1;

INSERT INTO t2
VALUES
(i);
COMMIT;
END;
/

What does 0 mean in sql?

1018

---

How do I run sql profiler?

1117

---

What is the use of function "module procedure" in pl/sql?

1233

---

Does pl sql work in mysql?

1033

---

What are the events on which a database trigger can be based?

1235

---

What is a relationship and what are they?

1225

---

what is the difference difference between procedure and packages

10531

---

Write a sql query to convert all character to uppercase after hypen.

1484

---

What does rownum mean in sql?

1088

---

How do I order by ascending in sql?

1076

---

What is meant by <> in sql?

1026

---

What is optimistic concurrency control? : Transact sql

1027

---

What is the importance of sqlcode and sqlerrm?

1389

---

Does db2 use sql?

1006

---

How do you delete a table?

1121

---