Want to periodically refreshed materialized views, creating a procedure and a job, perform error, when error is as follows:
ORA - 06550: line 1, column 112:
PLS - 00103: a symbol of "END" in need one of the following:
:=. (@ %;
Symbol ";" Is replaced with "END" to continue after,


My procedure is written such

 create or replace procedure proc_refresh 
Is 
The BEGIN 
Dbms_mview. Refresh (" aaaaa ", "F"); 
Dbms_mview. Refresh (" BBBBB ", "F"); 
commit; 
The RETURN; 
The EXCEPTION 
The when others then 
The rollback. 
return; 
END proc_refresh; 

Consult everybody, how the procedure statements should change?

CodePudding user response:

Procedure is not return

CodePudding user response:

 
The create or replace procedure proc_refresh 
Is 
The BEGIN 
The begin 
Dbms_mview. Refresh (" aaaaa ", "F"); 
Dbms_mview. Refresh (" BBBBB ", "F"); 
EXCEPTION when others then 
return; 
end; 
END proc_refresh; 

Job execution storage implicit commit, an error return automatically rolled back,