Re: Where to publish an article?
From: Alexander Kuznetsov <Alexander.Kuznetsov_at_marshmc.com>
Date: 12 Nov 2002 11:33:28 -0800
Message-ID: <ac5bc7c1.0211121133.1403c617_at_posting.google.com>
Date: 12 Nov 2002 11:33:28 -0800
Message-ID: <ac5bc7c1.0211121133.1403c617_at_posting.google.com>
Hi rajXesh,
> Here you are assuming that the client will remain, for the lack of a
> better word, alive, to COMMIT and release the lock. What if the client
> asks for a set of numbers and dies. Arent all the other processes
> locked out because the transaction is not committed and they cant get
> the range of values?
>
I think that's a very good point. It's very inconvenient and sometimes risky when you cannot COMMIT within a stored procedure. But in that environment there is no better choice yet. To my best knowledge that's not an issue with Oracle. Received on Tue Nov 12 2002 - 20:33:28 CET