| materialized view refresh problem - URGENT [message #75521] |
Tue, 13 July 2004 04:15 |
marcela
Messages: 6
Registered: July 2004
|
Junior Member |
|
|
i have created a materialized view on a on a table , but i have a problem to refresh these automatic with trigger.
i get the oracle8
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;
my errors
ORA-04092: isn´t possible COMMIT in trigger
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 869
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 852
ORA-06512: em "ANIID.T1_UPDATE_MW_TRIG", line 2
ORA-04088: error during the execute trigger 'ANIID.T1_UPDATE_MW_TRIG'
and a fill months ago this trigger function perfectly...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
