[cvsnt] Re: Repository auditing with Oracle

[Anthony Williams]

"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