After SQL - Refresh View Failing
Posted: Thu Jun 30, 2016 2:28 am
I searched a lot on this forum but no luck for my solution.
I am calling below script in my AFTER Sql to refresh my Materialized view but it is failing. I already tried below options:
1) EXEC DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true);
Error: ORA-00900: invalid SQL statement
2) CALL DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true);
Error: ORA-06576: not a valid function or procedure name
3) BEGIN
EXEC DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true);
END;
/
Error: ORA-06550: line 4, column 74:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
Can anyone help me with this.
Thanks!
I am calling below script in my AFTER Sql to refresh my Materialized view but it is failing. I already tried below options:
1) EXEC DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true);
Error: ORA-00900: invalid SQL statement
2) CALL DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true);
Error: ORA-06576: not a valid function or procedure name
3) BEGIN
EXEC DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true);
END;
/
Error: ORA-06550: line 4, column 74:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
Can anyone help me with this.
Thanks!