Sleep on Oracle.

If you want to use "dbms_lock" with the normal user, you should grant execute this package to user before he/she use.

--- Query --

SQL> select sysdate from dual;
exec dbms_lock.sleep(11);
select sysdate from dual;


-- Result --
SYSDATE
--------------------
25-NOV-2009 16:54:30

SQL>

PL/SQL procedure successfully completed.

SQL>
SYSDATE
--------------------
25-NOV-2009 16:54:41


== TaTsHuYa ==