Snowman wrote:What error are you getting?
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 had found another post re materialized views and was following the steps there, but they didn't work...
declare my_schema varchar(100); BEGIN select owner into my_schema from apex_applications where application_id=:APP_ID; dbms_refresh.refresh(my_schema||'.'||'REG_MON_BSA'); END;