编译报PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared

发现存储过程中有对 DBMS_LOCK.maxwait 的使用

查看dbms_lock 包

 SQL> desc  DBMS_LOCK
Element    Type  
--------------- ---------
NL_MODE CONSTANT
SS_MODE CONSTANT
SX_MODE CONSTANT
S_MODE CONSTANT
SSX_MODE CONSTANT
X_MODE CONSTANT
MAXWAIT CONSTANT
ALLOCATE_UNIQUE PROCEDURE
REQUEST FUNCTION
CONVERT FUNCTION
RELEASE FUNCTION
SLEEP     PROCEDURE

判定缺少执行权限

GRANT EXECUTE ON SYS.DBMS_LOCK TO 包所在用户