oracle sql 报错解决办法(国外英语资料).docVIP

oracle sql 报错解决办法(国外英语资料) Insert statement to modify the table, if in a row-level trigger to read or modify a mutating table, often will encounter ORA - 04091 error. For example, if use the select in the trigger or access the table where the trigger DML statements, will receive this error. Oracle8i, however, did not explain and 9 I document type before and after the row the trigger in the treatment of two different types of the insert statement (insert values into...... and select insert into......). When the difference: For each row level at the after type, no matter which insert statement triggers the trigger, it is not allowed to access the table that the trigger relies on in the trigger, and the test is as follows: SQL create table t1 (c1 number, c2 varchar2 (10)); The Table created SQL create or replace trigger tri_t1 2 after insert on t1 for each row 3 declare 4 cvar varchar2 (10); 5 the begin 6 select Y into cvar from t1 WHERE ROWNUM = 1; Here, the trigger table is accessed 7 the end; 8 / The Trigger created SQL insert into t1 values (1, a); ORA - 04091: the table TEST. The T1 is mutating, trigger/function may not see it ORA 06512: at test.tri_t1, line 4 Error during execution of trigger tes.tri_t1 SQL insert into t1 select 1, a from dual ORA - 04091: the table TEST. The T1 is mutating, trigger/function may not see it ORA 06512: at test.tri_t1, line 4 Error during execution of trigger test.tri_t1 For each row level triggers for before type, if you use insert into... The values statement triggers the trigger, and there is no problem accessing this table in the trigger. But if you use insert into select.. The from statement triggers the trigger, which is reported in the trigger for the ora-04091 error; Only in the Oracle 7 standard development documentation is this description: From the Application Developers Guide There is an exception to this restriction. For single row INSERTs, constraining tables are mutating the For AFTER row triggers, but not for BEF