存储过程报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
当存储过程里有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 ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8102208/viewspace-600804/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8102208/viewspace-600804/