materialized view refresh with trigger - URGENT [message #46966] |
Tue, 13 July 2004 08:44 |
marcela
Messages: 6 Registered: July 2004
|
Junior Member |
|
|
i get a trigger to refresh materialized view..
my trigger
create or replace trigger t1_update_mw_trig
after update on T1 (c11, c12)
for each row
begin
dbms_mview.refresh(para1, para2, para3...);
end;
and now it gives me this error
Error:ORA-04092: it´s not possible COMMIT in trigger
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 869
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 852
ORA-06512: em "ANIID.T15_UPDATE_MW_TRIG", line 2
ORA-04088: error during the execute trigger 'ANIID.T15_UPDATE_MW_TRIG'
my oracle is 9.0.1
and i don´t have any idea what´s the problem
this is Urgente...
|
|
|
Re: materialized view refresh with trigger - URGENT [message #46971 is a reply to message #46966] |
Tue, 13 July 2004 18:49 |
Jai Vrat Singh
Messages: 205 Registered: September 2002 Location: Singapore
|
Senior Member |
|
|
It it correct that you cannot commit inside a trigger, unless you make it an autonomous transaction. You error message says
ORA-04088: error during the execute trigger 'ANIID.T15_UPDATE_MW_TRIG'
This means that it is not this trigger where error originates but it is T15_UPDATE_MW_TRIG
You can see the source code of this trigger for what is happening? please query
select table_name,trigger_name from all_triggers where trigger_name like 'T%_UPDATE_MW_TRIG' to see what are the other triggers attached with this.
|
|
|