Ora-04092

[osman7king]

I have a trigger as following:

CREATE OR REPLACE TRIGGER TRG_REFRESH_MVIEW
AFTER INSERT
ON MV_AUDIT
BEGIN
DBMS_MVIEW.REFRESH('MV_SCH_STUDENT_AVAILABLE_COURS','A');
END;
 

When I execute an insert statement on the table MV_AUDIT, I got an error saying: "ORA-04092: cannot COMMIT in a trigger".

What is the solution for this problem?
may someone help me...

Best Regards
Osman

[rski]

Add PRAGMA clause

CREATE OR REPLACE TRIGGER TRG_REFRESH_MVIEW 
AFTER INSERT 
ON MV_AUDIT 
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN 
...