PLS-00907: cannot load library unit

数据库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

可以看到存储过程失效了，原因应该是存储过程有的表删了之后重新建导致的。