数据库alert日志报：
ORA-12012: error on auto execute of job 1301
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit SPR.P_WORKXXXX_USER (referenced by )
Oracle Error: PLS-00907
Error Description:
Cannot load library unit string (referenced by string)
Error Cause:
PL/SQL is unable to find and load a library unit that was previously available. This typically happens when you try to load a unit which references another library unit that is non-existent or invalid.
Action:
Provide the needed library unit.
SQL> select object_name,object_type,status from user_objects
where object_name = 'P_WORKXXXX_USER';
OBJECT_NAME OBJECT_TYPE STATUS
-------------------- --------------- -------
P_WORKXXXX_USER PROCEDURE INVALID
可以看到存储过程失效了，原因应该是存储过程有的表删了之后重新建导致的。