ORA-04091和Compound Trigger(Oracle 11g)

Trigger

常见有两种:行(Row Trigger)和语句(Statement Trigger)

还有：Instead of Trigger和Event trigger。

例子1-Row Trigger：

CREATE OR REPLACE TRIGGER client AFTERINSERT ON tt1 FOR EACH row

BEGIN

 dbms_application_info.set_client_info(userenv('client_info')+1 );

END;

例子2-Statement Trigger

CREATE OR REPLACE TRIGGER client_1 AFTERINSERT ON tt1

BEGIN

 dbms_application_info.set_client_info(userenv('client_info')-1 );

END;

ORA-04091错误

Tom Kyte有一篇文章很好的解释了ORA-04091。

http://www.oracle.com/technetwork/issue-archive/2008/08-sep/o58asktom-101055.html

部分摘抄如下：

Suppose wehave a table that includes country currency combinations with a primarycurrency. The following is sample data:

CountryCurrency   Primary_Currency

US      USD       Y

US      USN       N

US      USS       N

We need toenforce the rule that at