Re: Exclusive lock

Yoav,

you might be able to solve it with software. If you have a "lock table", where you put the primary key of the row that you do not want read (this is then the equivalent of taking a "Read Lock" - remember you must COMMIT this!). Instead of granting users access to the table, you give them a view which only returns rows where the primary key is not in the "lock table". Its a bit kludgy, and must be full of holes (given I thought this up spur of the moment) but the approach might work.

Dave O'Keeffe

Yoav wrote:
>
> Hi,
> Does anyone knows how can I issue a "real" exclusive lock in Oracle ?
> When saying "real", I mean that no one else can even SELECT the
> row/table.
>
> (I thought to use latch or try and update v$ tables).
>
> thanks,
>
> Joe
> ---------------------------------
> yoav_bz_at_netvision.net.il
 

-- 
For email replys remove "n0spam." from the above address