Soumi

• Jun 12th, 2006

 

Yes, you can fire 'commit' using autonomous transaction.

anjireddy

• Jun 16th, 2006

 

no u cant give commit in triggers

pankaj_gauba

 Profile Answers by pankaj_gauba Questions by pankaj_gauba

• Jun 22nd, 2006

 

Yes we write commit on trriger but only in autonomous transaction only. But is hardy recomended

srinivas

• Dec 1st, 2006

 

No we can't use commit in triggers, But we can use commit in Cursors

Regards

srinivas

PARI

• Mar 14th, 2007

 

NO we cannot use commit in triggers but  ya we can call a procedure in which commit is used but its not reccommended
pl/sql will not issue any error during compilation its only during  the execution of trigger ,it will give err message.

mohan kumar

• Apr 9th, 2007

 

Yes We can use commit statement in triggers with 10G.

Here is example :

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;
/

mohan

• Apr 9th, 2007

 

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;
/