DB version : 19c
I am trying to refresh a materialized view using the Oracle provided DBMS_MVIEW.REFRESH stored procedure.
But, I get the below errors despite passing valid arguments.
Any idea why ?
SQL> exec DBMS_MVIEW.REFRESH ( TAB => 'TEST_MV1', METHOD => 'C', ATOMIC_REFRESH => FALSE );
BEGIN DBMS_MVIEW.REFRESH ( TAB => 'TEST_MV1', METHOD => 'C', ATOMIC_REFRESH => FALSE ); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REFRESH'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
And the following is what I see when I do a DESC DBMS_MVIEW
In 12.1.0.2, I see pretty much the same arguments.
PROCEDURE REFRESH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TAB UNCL_ARRAY IN/OUT
METHOD VARCHAR2 IN DEFAULT
ROLLBACK_SEG VARCHAR2 IN DEFAULT
PUSH_DEFERRED_RPC BOOLEAN IN DEFAULT
REFRESH_AFTER_ERRORS BOOLEAN IN DEFAULT
PURGE_OPTION BINARY_INTEGER IN DEFAULT
PARALLELISM BINARY_INTEGER IN DEFAULT
HEAP_SIZE BINARY_INTEGER IN DEFAULT
ATOMIC_REFRESH BOOLEAN IN DEFAULT
NESTED BOOLEAN IN DEFAULT
OUT_OF_PLACE BOOLEAN IN DEFAULT
SKIP_EXT_DATA BOOLEAN IN DEFAULT