Home » SQL & PL/SQL » SQL & PL/SQL » No wait ..
No wait .. [message #247273] Mon, 25 June 2007 05:53 Go to next message
akkumar81
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..

Regards,

Arun..
Re: No wait .. [message #247276 is a reply to message #247273] Mon, 25 June 2007 05:59 Go to previous message
balaji23_d
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: Tue Dec 06 06:32:28 CST 2016

Total time taken to generate the page: 0.09981 seconds