Rolling back sequences?

Is it possible to roll back a sequence to its original point before a transaction started, if the transaction fails? I need to be able to log out reproducible SQL from a complex precedure. Oracle 9.2, windows platform.

Here's a typical example:

select train_route_seq.nextval from dual;

   NEXTVAL

    311845

1 row selected.

rollback

Rollback complete.

select train_route_seq.nextval from dual;

  NEXTVAL

    311846

1 row selected.

Thanks,

Dean Received on Mon Apr 03 2006 - 22:15:39 CDT