ORACLE写存储过程报错

[FriendQ]

CREATE OR REPLACE PROCEDURE ONOFFPOR IS BEGIN 
EXEC DBMS_MVIEW.REFRESH('ONOFF_MV',METHOD => 'FAST');
END;
/

Warning:Procedure created with compilation errors

请问这是什么情况啊

[睿智天成]

CREATE OR REPLACE PROCEDURE ONOFFPOR IS BEGIN 
--EXEC DBMS_MVIEW.REFRESH('ONOFF_MV',METHOD => 'FAST');
dbms_mview.refresh(TAB=>'ONOFF_MV',METHOD=>'FAST',PARALLELISM=>8);
END;

[gangma2]

上面是创建存储过程的编译过程中发生了错误，将exec去除就可以编译通过了。 CREATE OR REPLACE PROCEDURE ONOFFPOR IS BEGIN DBMS_MVIEW.REFRESH('ONOFF_MV',METHOD =>'FAST'); END;