Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Nowait clause for insert statements?

Nowait clause for insert statements?

From: Claus Jensen <cje_at_stibo.com>
Date: 1998/05/08
Message-ID: <35530E55.75F1@stibo.com>#1/1

Is there any way to check if an insert will be blocked by a lock. I am thinking of something similar to "select for update nowait", but for insert statements. Alternatively can I query the dba_locks to check it that way?

Thanks in advance for any ideas...
Please respond by e-mail.

-- 

------------------------------------------------------------------
Claus Jensen The Stibo Technology Group...since 1794 Stibo Datagraphics Inc. 400 Franklin Road E-mail: cje_at_stibo.com Marietta Phone: (001) 770 425 3282, ext. 197 GA 30067-7735 Fax: (001) 770 425 3012
------------------------------------------------------------------
"From a programmers point of view, a user is just a peripheral, that types when you issue a 'read' command" - Peter Williams
------------------------------------------------------------------
Received on Fri May 08 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US