When I run the following sqlplus command from the commandline, I get results as I would expect.
Notice the sql script I am running is a simple select statement.
What I would like to do is call a stored procedure in a similar manner, however I do not know what syntax to use.
For example, I would like to run this sql script:
begin
DBMS_SNAPSHOT.refresh('DW_TEMP_MV', method => 'C', atomic_refresh=>false);
end;
But when I save that in a text sql script file, and then try to run it (like the orange-circled commandline command above) I do not believe it actually runs the procedure.
Can someone help me solve this (probably simple) problem?