Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Triggers recursive call

Triggers recursive call

From: Jordi Sanmarti <JSanmarti_at_tss.com.pe>
Date: Wed, 22 Nov 2000 19:36:29 -0500
Message-Id: <10688.122778@fatcity.com>

        Hi to all,

        Does anybody know how setup the database to avoid any trigger recursive call?

	Look at this dummy example:
	Trigger is "statement" related type trigger (not of "for each row"
type).
	If I run the below using "for each row" clause I get mutating error.

	create or replace trigger tr_booking after update on booking
	declare
	  cont number;
	begin

...
update booking set col1 = col1 + 10 where col2 = 'A';
...
end; /
Received on Wed Nov 22 2000 - 18:36:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US