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 -> Re: complex locking and sequence generation

Re: complex locking and sequence generation

From: Andy Hardy <junkmail_at_[127.0.0.1>
Date: Mon, 29 May 2006 13:09:31 +0100
Message-ID: <SZiIExB7RueEFAod@[127.0.0.1]>


In message <e5bntl0snn_at_news1.newsguy.com> , steve <steve_at_aol.com> writes
>Hi,
>
>I need to generate sequences that are sequential , even with multiple users.

Perhaps have a routine to generate the sequence which uses dbms_lock to serialize its access?

-- 
Andy Hardy. PGP ID: 0xA62A4849
Received on Mon May 29 2006 - 07:09:31 CDT

Original text of this message

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