ORA-06576: not a valid function or procedure name

ORA-06576: not a valid function or procedure name

Cause:

This is syntax error due to missing argument.

kIsH@xHydra<>EXEC DBMS_SCHEDULER.RUN_JOB('MV_MVREMOTE_REFRESH1');
BEGIN DBMS_SCHEDULER.RUN_JOB('MV_MVREMOTE_REFRESH1'); END;

*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at line 1


kIsH@xHydra<>EXEC DBMS_SCHEDULER.RUN_JOB('MV_MVREMOTE_REFRESH');
BEGIN DBMS_SCHEDULER.RUN_JOB('MV_MVREMOTE_REFRESH'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 775:
PLS-00103: Encountered the symbol "" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "" to continue.
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at line 1

Solution:

Check the text from dba_source to find the function and its argument. If this “use_current_session ” value is set to true, then the error occur but setting the value to false executes the precedure successfully

kIsH@xHydra<>select name,type,line,text from dba_source where text like '%DBMS_SCHEDULER%';


NAME                                                                                                                             TYPE               LINE
-------------------------------------------------------------------------------------------------------------------------------- ------------ ----------
TEXT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DBMS_SCHEDULER                                                                                                                   PACKAGE             667
  logging_level           IN PLS_INTEGER  DEFAULT DBMS_SCHEDULER.LOGGING_RUNS,

DBMS_WORKLOAD_CAPTURE                                                                                                            PACKAGE              19
  --    Jobs (DBMS_SCHEDULER/DBMS_JOB) will not be captured, no matter how

DBMS_REFRESH                                                                                                                     PACKAGE              38
  --   or FALSE indicates that DBMS_SCHEDULER will be used to create the

MGMT_CONFIG                                                                                                                      PACKAGE BODY        105
        DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_' || inst_id,'instance_id',inst_id);

MGMT_CONFIG                                                                                                                      PACKAGE BODY        109
      DBMS_SCHEDULER.ENABLE (p_job_name || '_' || inst_id);

MGMT_CONFIG                                                                                                                      PACKAGE BODY        111
      -- DBMS_SCHEDULER.RUN_JOB(p_job_name || '_' || inst_id,FALSE);

MGMT_CONFIG                                                                                                                      PACKAGE BODY        142
            DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_2_' || inst_id,'instance_id',inst_id);

MGMT_CONFIG                                                                                                                      PACKAGE BODY        146
          DBMS_SCHEDULER.ENABLE (p_job_name || '_2_' || inst_id);

MGMT_CONFIG                                                                                                                      PACKAGE BODY        164
        DBMS_SCHEDULER.RUN_JOB(JOB_NAME);

MGMT_CONFIG                                                                                                                      PACKAGE BODY        165
        DBMS_SCHEDULER.RUN_JOB(STATS_JOB_NAME);

DBMS_FEATURE_REGISTER_ALLHWM                                                                                                     PROCEDURE           277
   * DBMS_SCHEDULER   HWM is number of jobs per day

DBMS_FEATURE_REGISTER_ALLHWM                                                                                                     PROCEDURE           281
     HWM_DBMS_SCHEDULER_STR CONSTANT VARCHAR2(1000) :=

DBMS_FEATURE_REGISTER_ALLHWM                                                                                                     PROCEDURE           299
      ('HWM_DBMS_SCHEDULER',

DBMS_FEATURE_REGISTER_ALLHWM                                                                                                     PROCEDURE           301
       HWM_DBMS_SCHEDULER_STR,

SYSLSBY_EDS_DDL_TRIG                                                                                                             TRIGGER             103
         DBMS_SCHEDULER.CREATE_JOB(


15 rows selected.


kIsH@xHydra<>BEGIN
               DBMS_SCHEDULER.RUN_JOB
               (
                job_name => 'MV_MVREMOTE_REFRESH1',
                use_current_session => FALSE -- this parameter should be included with false
               );
          END;
          /  2    3    4    5    6    7    8

PL/SQL procedure successfully completed.