Re: Using application seq. no. definition without commit (C/S env)

Yochi Wieman wrote in message <34A7B173.7533_at_shani.net>...
>Using application seq. no. definition without commit (C/S env).
>
>In an application which defines seq. numbers (not ORACLE SEQ.),
>at multiple levels within the application, in an Oracle table,
>in the same D.B. as other application data,
>how is it possible to increment the seq. no. by multiple tasks
>simultaneously within the application without COMMIT??

    You can't, orcale sequences increment themselves on their own so you need to get that nextval when you're ready to use it (before the insert) if you don't want to be left with holes...

    You could try getting the sequences current value and adding 1 to it. But that would generate an error if the sequence isen't 'open'.

    Eric Veilleux
    eveilleu_at_ers.ca Received on Mon Dec 29 1997 - 00:00:00 CST