Re: Re : Row Level Share Locks

From: Alice <Alice.Explorer_at_mtu-net.ru>
Date: Fri, 18 Sep 1998 23:57:08 +0400
Message-ID: <6tudo6$7kp$1@ns.mtu.ru>

Thanks for the hint.
I'll check your suggestions next Monday when I get to work. Anyway, I'm sure I'll have to study the dbms_lock package in much more detail.
Thanks for the insight.

Regards,
George.

>Ok, that would be a use of it. Here is a way to do it in Oracle. We will
use
>the dbms_lock package. The client that wants a shared lock on a customer
row
>will have to call the procedure "share_lock_customer( customerid )" to
share
>lock that row -- many people can call that routine successfully. The
updater of
>the customer table will not have to do anything special, a trigger will
take
>care of them.
>
Received on Fri Sep 18 1998 - 14:57:08 CDT