これはOK。
BEGIN DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC; END; /
これもOK。
EXECUTE DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC;
これはダメ。
BEGIN EXECUTE DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC; END; / 2 3 4 EXECUTE DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC; * ERROR at line 2: ORA-06550: line 2, column 10: PLS-00103: Encountered the symbol "DBMS_STATS" when expecting one of the following: := . ( @ % ; immediate The symbol ":=" was substituted for "DBMS_STATS" to continue.