Oracle manual refresh of materialized views

Recently, you need to manually refresh a materialized view after the documents are successfully submitted.

The solution was to call dbms_refresh.refresh ('materialized view name') on the after update trigger of the table. An error was reported during the test. Cause of error: When you use dbms_refresh.refresh to refresh the materialized view, an implicit commit transaction is committed by default. It is estimated that the commit transaction conflicts with the trigger's implicit commit transaction commit, so an error is returned. After modification to the front-end call refresh, the test is normal. PB front-end testCodeAs follows:

Declare dbms_refresh procedure for dbms_refresh.refresh ('materialized view name ');
Execute dbms_refresh;
Close dbms_refresh;

Note: dbms_refresh.refresh is the process of dbms_refresh package.

Http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/rarrefreshpac.htm