[cvsnt] Re: Repository auditing with Oracle

Anthony Williams anthony.ajw at gmail.com
Wed Jan 11 15:05:49 GMT 2006


Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.


"Paulo Soares" <psoares at consiste.pt> writes:

>> > SELECT ID_SEQUENCE.CURRVAL FROM DUAL
>> 
>> and now, it occurs to me that you might also be able to use 
>> this last SELECT
>> in conjuction with a trigger that did the actual update.
>
> As long as you are the only writer using the sequence. 

As I understand it, CURRVAL returns the last generated sequence value for this
connection; consequently you cannot use it until you have used NEXTVAL within
this session.

> If you are you
> may as well generate the number internally in the cvsnt server. A better
> way is to call
>
> SELECT ID_SEQUENCE.NEXTVAL FROM DUAL
>
> and use the returned value for all the insertions. It would also work
> with multiple writers.

This was one of my suggestions above.

Anthony
-- 
Anthony Williams
Software Developer
Just Software Solutions Ltd
http://www.justsoftwaresolutions.co.uk



More information about the cvsnt mailing list
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook