Info about Oracle Sequences

[soans]

I have a sequence used by multiple users. Some users want to generate blocks of continous sequential numbers at a time.
I believe I can generate these numbers with a loop statement.
I was wondering if the sequences can be locked when someone is accessing it so they can get the block of data they want without any interruption in the sequence.
Thanks
soans [sig][/sig]

 

[carp]

No. If they need their own numbers, you will probably have to generate them programatically instead of via a sequence. [sig][/sig]

 

[Advocate]

Depending on how many users you have and how often they access sequence, have you tried the cache option ?
I use Sql-Navigator front-end to set cache size, cache value enable and guaranteed order. It may work for your particular requirements ... [sig]<p>Best of Irish Luck, David.<br><a href=mailto:djwilkes@hotmail.com>djwilkes@hotmail.com</a><br>[/sig]