Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Refreshing Materialized view from APEX process is causing errors

SnowmanJan 21 2013 — edited Jan 22 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Jan 21 2013
4 comments
1,235 views