Sequence trouble in V6 **SOLVED** (?)

Inspired by my posting of a few minutes ago, I have devised my own solution to the problem with sequences: I turn caching off with "NOCACHE" (not with "CACHE 0"), and now I can get at the "last" value with

  SQL> select LAST_NUMBER from ALL_SEQUENCES where SEQUENCE_NAME='SEQ3';

  LAST_NUMBER

            4

This number is one greater than wot I expect, but that could be my fault too ("LAST_NUMBER" is defined in the DD as "Last sequence number written to disk", whatever that means). Anyway, at least it seems *always* to be one greater than the last number drawn from the sequence.

Apologies to anyone who thought my posting wasted their time.

Paul "some of the egg on my face is left over from last time" Singleton

  __   __    Paul Singleton (Mr)           JANET: paul_at_uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul_at_cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 583477 << NEW for
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082     1993