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

Home -> Community -> Usenet -> c.d.o.server -> Re: Simultaneous INSERTs - one of them "hangs"

Re: Simultaneous INSERTs - one of them "hangs"

From: David Russell <user_at_msn.com>
Date: 1997/11/25
Message-ID: <01bcf9e6$76210100$594195c1@thor>#1/1 







The best way to avoid this problem is to use Oracle Sequences so that no
two sessions can generate the same primary key. If you can not rewrite for
this and you are using OCI you can specify that any DML statement uses NO
WAIT, but this flag is only available from OCI.



Regards


David Russell
 
Received on Tue Nov 25 1997 - 00:00:00 CST












Original text of this message













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