I have a table called years in my database that is used for populating
a year dropdown list on various end user web forms. I'm looking for a
solution for automatically adding the next year to this table at a
specified date, once a year, on a recurring yearly basis (i.e. every
December 1st, the next year is automatically added to the years
table). The application is a java web application, using
CallableStatements to execute plsql packages, functions, etc on the
database side. It may be distributed to many clients. I thought of
creating stored procedure, then scheduling it thru dbms_job to run
once a year. Is there a better solution? What would be the most
efficient way to do this?
Received on Fri Mar 19 2004 - 11:51:50 CST
