begin
ad_mv.create_mv('XXABC_TEST_MV',
'create materialized view XXABC_TEST_MV'||
' build deferred refresh on demand as '||
' select /*AUTOREFRESH*/ * from per_jobs');
end;
Note: While using this ad_mv.create_mv, you should not call plsql function, procedure calls in the MV sql statement.
