ORA-12012 job解決

今天監控日誌報錯如下
Mon Sep 21 00:00:04 2015
Errors in file /u01/app/oracle/diag/rdbms/xyxdb/xyxdb/trace/xyxdb_j000_52491.trc:
ORA-12012: 自動執行作業 5 出錯
ORA-06550: 第 1 行, 第 96 列:
PLS-00201: 必須宣告識別符號 'SL.PRO_UPDATEYESTERDAYSTAT'
ORA-06550: 第 1 行, 第 96 列:
PL/SQL: Statement ignored
Mon Sep 21 02:00:00 2015
Closing scheduler window

SQL> select what from dba_jobs where job=5;

WHAT
--------------------------------------------------------------------------------
SL.PRO_UPDATEYESTERDAYSTAT;

SQL>


重新編譯儲存過程
SQL> alter procedure sl.pro_updateTodayStat compile;

Procedure altered.