create or replace procedure test as
v_sal varchar2(30);
cursor c1 is select mview_name into v_sal from USER_MVIEWS where mview_name='T_DOC';
begin
dbms_mview.refresh(':v_sal');
end;
SQL> exec test;
BEGIN test; END;
*
ERROR 位于第 1 行:
ORA-00931: 缺少标识
ORA-06512: 在"SYS.DBMS_UTILITY", line 125
ORA-06512: 在"SYS.DBMS_UTILITY", line 160
ORA-06512: 在"SYS.DBMS_UTILITY", line 202
ORA-06512: 在"SYS.DBMS_SNAPSHOT", line 831
ORA-06512: 在"OA.TEST", line 6
ORA-06512: 在line 1
