Locking issues

From: David Kaiser <davidk_at_sfmic.com>
Date: 1997/02/14
Message-ID: <01bc1a96$41a0b900$5c1f90ce@davidk.sfmic.com>#1/1

Oracle's default locking method causes C/S applications to wait for a lock to clear. This can make the user think that their program crashed, when they are actually waiting for a lock.

The only way around this that I've seen is to have the client program timeout after waiting for a certain period of time.

Is there anyway with Oracle 7.3 to have Oracle return an error message notifying the client program that the record it is trying to update is locked?

-- 

+---------------------------------------+-------------------------------+


| David Kaiser                          | e-mail: davidk_at_sfmic.com      |

| Project Manager                       |    WWW: http://www.sfmic.com  |

| State Fund Mutual Insurance Company   |                               |

| 7500 Flying Cloud Drive, Suite 900    |  voice: 612.914.1317          |

| Eden Prairie, MN 55344  USA           |    fax: 612.944.1169          |

+---------------------------------------+-------------------------------+

Received on Fri Feb 14 1997 - 00:00:00 CST