Author: mittfirmma
Speed: 17 Mb/s
Сompaction: zip
Amount: 24.83 MB
Dаtе аddеd: 2.09.2012
Total downloads: 6247
.
.
.
.
.
.
.
.
.
.
RE: Why dbms_lock.sleep is not working for.
That sounds like execute on dbms_lock has been granted to a role, rather than directly to the procedure's schema. You'll need to get execute on dbms_lock granted
53 DBMS_LOCK. The DBMS_LOCK package provides an interface to Oracle Lock Management services. You can request a lock of a specific mode, give it a unique name RE: Why dbms_lock.sleep is not working for.
dbms sleep
DBMS_OUTPUT - Computer Science and.
Ask Tom "dbms_lock.sleep procedure"
DBMS_LOCK - Oracle Documentation
dbms lock must be declared | Oracle Forums
Just another nerd blog It seems that in order to use DBMS_LOCK you need to be granted EXECUTE on DBMS_LOCK by SYS (or SYSTEM?).
Oracle “sleep” procedure: DBMS_LOCK.SLEEP.
dbms sleep
All trademarks and copyrights within the FreeLists archives are owned by their respective owners. Everything else ©2000-2013 Avenir Technologies, LLC.
Sudhanshu -- Thanks for the question regarding "dbms_lock.sleep procedure", version 8.1.7