Select... for update (nowait)

From: Maxime Tardif <maxime.tardif_at_cgi.ca>
Date: Tue, 1 Feb 2000 15:36:46 -0500
Message-ID: <949437076.136225@viz.drev.dnd.ca>

I use Oracle 8i enterprise database. With my first session, I write this SQL statement:
"select * from po_cat where po_cat_id =1 for update nowait;"

With an other session, I update this record. The updating process lag and it executes when the first connection commit or rollback. I use the nowait option and want that process return an exception (the record is busy...).

Why nowait option doesn't work ? and how I can resolve this problem ? Received on Tue Feb 01 2000 - 14:36:46 CST