title: How to refresh materialized view in oracle
body: <p>Iam trying to refresh the materialized view by using:</p>
  
  <pre><code>DBMS_MVIEW.REFRESH('v_materialized_foo_tbl')
  </code></pre>
  
  <p>But it's throwing invalid sql statement. </p>
  
  <p>Then I have created a stored procedure like this:</p>
  
  <pre><code>CREATE OR REPLACE 
  PROCEDURE MAT_VIEW_FOO_TBL 
  IS
  BEGIN
     DBMS_MVIEW.REFRESH('v_materialized_foo_tbl')
  END MAT_VIEW_FOO_TBL IS;
  </code></pre>
  
  <p>This procedure has been created successfully but when i am calling this procedure with </p>
  
  <pre><code>MAT_VIEW_FOO_TBL;
  </code></pre>
  
  <p>it's throwing an error again.</p>
  
  <p>Kindly suggest a solution for this issue.</p>
  
  <p>Thanks,
  Srinivas</p>