I need the ability to use custom locks at a session level (outside the scope of a transaction) in oracle.
In MSSQL I am using sp_getapplock, sp_releaseapplock.
How can I achieve the same functionality in Oracle?
DBMS_LOCK Package
This will do what you want:
dbms_lock.allocate_unique('control_lock', v_lockhandle);
v_result := dbms_lock.request(v_lockhandle, dbms_lock.ss_mode);
...
v_result := dbms_lock.release(v_lockhandle);
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_lock.htm
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With