Re: Read only row level share lock ? URGENT!!!

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 1 Sep 1999 09:01:16 +0200
Message-ID: <936169319.13775.0.pluto.d4ee154e@news.demon.nl>

Hi Anurag,

Either issue a
lock table <table_name> in row share mode or issue
select for update
before the actual update
Personally I prefer this method, because in PL/SQL you can wrap the select in a cursor and
use where current of <cursor_name> in the update. This refers to the rowid and bypasses any index.
NB: Any update without one of those two statements will automatically escalate into a row exclusive lock

Hth,

--
Sybrand Bakker, Oracle DBA

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:37CCC735.EFFAF800_at_synergy-infotech.com...
> Hi,
> Is it possible to have a read only shared lock on a row.
> Actually i want to allow as many users to have a read only row level
> shared lock , but when somebody tries to select for update it should
> fail. Is this possible in Oracle?
> please let me know how .
>
> Thanks
> anurag
>
> also reply at
> anurag_at_synergy-infotech.com
>
Received on Wed Sep 01 1999 - 02:01:16 CDT