Hi Im using the following trigger to refresh my mview.
BEGIN
DBMS_SNAPSHOT.REFRESH(
LIST => 'EQUIPMENT_FEATURES_MVIEW'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE);
END;
I change the table from which the mview is created and does a commit, it throws the following error..
error ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "SYS.DBMS_SNAPSHOT",
line 2732 ORA-06512: at "SYS.DBMS_SNAPSHOT",
line 2712 ORA-06512: at "PE_TEST_SCHEMA.EQUIPMENT_FEATURE_T1",
line 3 ORA-04088: error during execution of trigger 'PE_TEST_SCHEMA.EQUIPMENT_FEATURE_T1'
Any help would be very really appreciated