oracle pl/sql DBMS_LOCK 错误

在Oracle PL/SQL中，我想测试睡眠功能。我正在使用 hr 模式。但它给了我错误：

PLS-00201: identifier 'DBMS_LOCK' must be declared

code:

begin
 DBMS_LOCK.Sleep( 60 );
end;
/

你应该授予执行 http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9013.htm将该包添加到您的架构中

grant execute on <object> to <user>;

e.g.

connect as sys
grant execute on SYS.DBMS_LOCK to someuser;