PL/SQL script in sql-maven-plugin throws invalid SQL statement

Question

I am trying to update my materialized view using sql-maven-plugin but its says

Caused by: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
ORA-06512: at line 2

Query :

begin
    EXECUTE IMMEDIATE 'DBMS_MVIEW.REFRESH(''M_CUSTOMER'')';
end;

Even after spending hours and hours on this, i am not able to figure out the issue. Thanks in advance.

The queries I want to execute are not simple DDL queries but DBMS_MVIEW package or other packages. Other answers have the solution for DDL but not for package.

Project structure

Answer 1

You have not enough or too many levels of indirection here :-)

You either want:

begin
    DBMS_MVIEW.REFRESH('M_CUSTOMER');
end;

or

begin
    EXECUTE IMMEDIATE 'begin DBMS_MVIEW.REFRESH(''M_CUSTOMER''); end;';
end;

with the former being the most likely.