Recently, you need to manually refresh a materialized view after the documents are successfully submitted. In the initial solution, the AfterUpdate trigger in the table calls dbms_refresh.refresh (
Recently, you need to manually refresh a materialized view after the documents are successfully submitted. The solution was to call dbms_refresh.refresh (
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. The PB front-end test code is as 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.