Posted on 2011-02-22
I have a webpage html report created a SP (pl/sql) that basically displays derived stock inventory numbers stored in a reporting table and are calculated every night.
I have a requirement to take a snapshot of this report and store it as static HTML report in a table.
The snapshots I want are every 3 months. so for this year i need a copy 3/31/3011, 6/30/2011, 9/30/2011, 12/31/2011, etc.
I should also display a link to call each static report archived.
I was thinking of creating:
1) A table to store the webpages when the reprot is run every 3 months.
2) a stored procedure that calls the current webpage and save the HTML to a CLOB variable that is inserted into the table.
3) a job that runs every 3 months.
Any ideas on the best way to design and code this.