Re: No Wait for Update of locked row?

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/02/20
Message-ID: <330bc3e6.5161972@nntp.mediasoft.net>#1/1

On Wed, 19 Feb 1997 15:33:19 -0800, Gene Plagge <gene_sal_at_pacbell.net> wrote:

>Hi,
>
>One of our developers needs to have the functionality of the NOWAIT
>clause in a SELECT statement when he is doing an UPDATE. He needs to
>have the UPDATE fail (with Ora error message) if the row he is
>attempting to update is locked.
>
>Any ideas on how to approach this.
>
>Oracle tech support had no clue...
>
>
>Thanks for any help.
>
>
>Gene Plagge
>WorldxChange, Inc.
>619-452-0041 x8466
>gplagge_at_wxl-cts.com

Basically you can't.

If you don't want your update to block you need to use a select for update.

If you would like to read about this, we just had a thread going on about this subject. goto http://www.dejanews.com and set up a 'power filter' for the

newsgroup: comp.databases.oracle.*
subject: locking issues

You'll get 30 or so messages on the subject.

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Thu Feb 20 1997 - 00:00:00 CST