存储过程报PLS-00201: identifier 'SYS.DBMS_LOCK' must be

存储过程报PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared错误，解决方法
当存储过程里有dbms_lock.sleep(60); 语句时，如果报以下错误：
LINE/COL ERROR
-------- -----------------------------------------------------------------
5/10     PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared
5/10     PL/SQL: Statement ignored

 

解决办法：

请用GRANT EXECUTE ON SYS.DBMS_LOCK TO <存储过程所在用户>;