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: Jerel McDonald <jerel_at__delete_azstarnet.com>
Date: 1997/11/26
Message-ID: <01bcfa73$f0f803a0$a222c5a9@monsoon.ehi.tsidss.com>#1/1

Is there a reliable way when using sequences to get the unique key generated by the Oracle Sequence immediately after doing the insert?

David Russell <user_at_msn.com> wrote in article <01bcf9e6$76210100$594195c1_at_thor>...
> 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.
Received on Wed Nov 26 1997 - 00:00:00 CST

Original text of this message

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