Re: schedule rename partitions

Posted by Roshan on Oct 10, 2017; 7:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/schedule-rename-partitions-tp3462p3939.html

Hi,

the error

SQL> BEGIN
EXECUTE DBMS_SCHEDULER.RUN_JOB('job_mobiledata');

END;
/  2    3    4    5
EXECUTE DBMS_SCHEDULER.RUN_JOB('job_mobiledata');
        *
ERROR at line 2:
ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "DBMS_SCHEDULER" when expecting one of the
following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "DBMS_SCHEDULER" to continue.



is due to the 'Declare' part which should not have been included in the procedure. Instead, we should have  replaced it with 'IS'

Now it is executing properly.

Thanks for support.

Regards,
Roshan