REFRESH_ALL_MVIEWS - wrong number or types of arguements
All,
I am trying use the REFRESH_ALL_MVIEWS and I am quite stuck here.
I just don't see where it's wrong. Can someone take a look at it?
declare
v_failures number(12) := 0;
begin
DBMS_MVIEW.REFRESH_ALL_MVIEWS(v_failures,'C',TRUE, TRUE, FALSE, FALSE);
end;
SQL> /
DBMS_MVIEW.REFRESH_ALL_MVIEWS(v_failures,'C',TRUE, TRUE, FALSE, FALSE);
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PLS-00306: wrong number or types of arguments in call to 'REFRESH_ALL_MVIEWS'
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
Thanks,
Kathy