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

From: Olaf Naumann <onaumann_at_netcologne.de>
Date: 1998/01/02
Message-ID: <01bd17c0$e734d180$0100007f@lapnau>#1/1

> 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 should use an oracle sequence because this is the purpose they are made for: providing unique numbers in an multi tasking / - user environment. every

SELECT MYSEQUENCE.NEXTVAL FROM DUAL increments your sequence BEFORE a commit! (in fact there is no way to rollback a sequence)

olaf naumann Received on Fri Jan 02 1998 - 00:00:00 CST