This discussion is archived
4 Replies Latest reply: Jan 22, 2013 12:05 AM by flavioc RSS

Refreshing Materialized view from APEX process is causing errors

Snowman Newbie
Currently Being Moderated
Hi,

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points