Home » SQL & PL/SQL » SQL & PL/SQL » No wait ..
No wait .. [message #247273] Mon, 25 June 2007 05:53 Go to next message
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

My oracle version 9i.

In cursor part locking a record for update of [column name][nowait].

why we are using [nowait].what is the main purposes of this nowait.

Expecting Your replies for my basic question..


Re: No wait .. [message #247276 is a reply to message #247273] Mon, 25 June 2007 05:59 Go to previous message
Messages: 123
Registered: February 2007
Senior Member

NOWAIT: If NOWAIT is NOT specified and a row to be locked is locked by another transaction, SELECT...FOR UPDATE will wait indefinitely until the lock is released. If NOWAIT is specified and a row to be selected is locked by another transaction, the SELECT...FOR UPDATE will return immediately with a "ORA-00054: resource busy and acquire with NOWAIT specified" error.
Previous Topic: Problem while creating view
Next Topic: Anybody can help for this small query
Goto Forum:

Current Time: Fri Jul 21 12:15:49 CDT 2017

Total time taken to generate the page: 0.24352 seconds