今天监控日志报错如下
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;
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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24486203/viewspace-1805608/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24486203/viewspace-1805608/