在Oracle中是否有与sp_getapplock，sp_releaseapplock等效的文件 [英] Is there an equivalent to sp_getapplock, sp_releaseapplock in oracle

问题描述

我需要能够在oracle的会话级别(事务范围之外)使用自定义锁.

I need the ability to use custom locks at a session level (outside the scope of a transaction) in oracle.

在MSSQL中，我正在使用sp_getapplock，sp_releaseapplock.

In MSSQL I am using sp_getapplock, sp_releaseapplock.

如何在Oracle中实现相同的功能?

How can I achieve the same functionality in Oracle?

推荐答案

DBMS_LOCK软件包

这将满足您的要求:

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

这篇关于在Oracle中是否有与sp_getapplock，sp_releaseapplock等效的文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！