SQL & PL/SQL

Hi Experts,

I am working on Database version: 10.2.0.5.0 (10G).

Currently I got stuck with one error:
ORA-12012: error on auto execute of job 163~ORA-06550: line 1, column 96:~PLS-00201: identifier 'PROC_REF_MV_AMENDMENT' must be declared~ORA-06550: line 1, column 96:~PL/SQL: Statement ignored

I have one materialized view MV_AMENDMENT_DASHBOARD.

To refresh MView I have created procedure PROC_REF_MV_AMENDMENT as below:

Create procedure PROC_REF_MV_AMENDMENT
IS
BEGIN
--have removed codes like dropping index and recreating it.
dbms_mview.refresh('MV_AMENDMENT_DASHBOARD','C');
DBMS_STATS.GATHER_TABLE_STATS (
   ownname          => 'schemaname',
   tabname          => 'MV_AMENDMENT_DASHBOARD',
   estimate_percent => 30);
END

Have created job like:

dbms_job.submit(
job_no,
'PROC_REF_MV_AMENDMENT;', 
trunc(SYSDATE), 
'trunc(SYSDATE+1)+(10/24)');

But I am getting above mentioned error, at the time of its auto-execution.

Manually I am able to execute this job using DBMS_JOB.RUN(job_no).

I have checked procedure status as valid.

Will really appreciate your help.

Many Thanks