MV refresh

Is it possible that when a MV is being refreshed but gets some kind of error and ends up an empty MV in 10g?

exec DBMS_MVIEW.refresh('MYMV','C'); - here is how we refresh.

The application team wants me to write a procedure to refresh MV and capture the error message if it fails and restore the MV to the previous state. How do I capture the error? I know I can show errors in SQL*PLUS.

Thanks,

Roger Xu

--
http://www.freelists.org/webpage/oracle-l