Database Administration (MOSC)

MOSC Banner

REFRESH_ALL_MVIEWS - wrong number or types of arguements

edited Jul 22, 2016 9:52AM in Database Administration (MOSC) 1 commentAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center