4 Replies Latest reply: Jan 22, 2013 2:05 AM by flavioc RSS

    Refreshing Materialized view from APEX process is causing errors


      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