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