Automatically reset Sequence to initial value?

I want to have a sequence automatically reset to its initial value (i.e., its START WITH parameter) on January 1, 1998 at 12:01 a.m., and the first of every year thereafter.

I know it is possible to manually type ALTER SEQUENCE statements to accomplish this, but is there a way to do it automatically?

I am using Oracle 7.3.2.2.1.

Thanks in advance for your help.

Todd Owers
ToddO_at_gcr1.com Received on Fri Oct 17 1997 - 00:00:00 CDT