Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simultaneous INSERTs - one of them "hangs"
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