SQL & PL/SQL

Hi,

I created one Materialized View Refresh Group. and executing in one schema.

begin
dbms_refresh.refresh ('TEST');
end.

There are many reason of failure of execution of MV Refresh Group (Like Network Issue, Change in base table). At the time of failure of Execution of refresh group oracle display an error code and error message.

Question:-
Could you pelase suggest any system table or view in oracle database which can hold any error message and error number? I have to fetch this error message without exception handling in pl/sql block.

Thanks and Regards,
Vinod Gupta.