Refreshing Materialized view from APEX process is causing errors
SnowmanJan 21 2013 — edited Jan 22 2013Hi,
I have created a materialized view, and am attempting to create a process in APEX to refresh the mview on a button click.
I have been reading the documentation on Materialized Views and think I am more confused now than when I started.
Do I need to add my mview to a refresh group to enable me to use the DBMS_REFRESH.REFRESH command from an APEX process?
I have had a few attempts at getting it working, but to no avail yet.
Any help would be appreciated.
Cheers, Greg