• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

StoriingStaticHTMLReport

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.


0
sam15
Asked:
sam15
  • 3
  • 3
1 Solution
 
schwertnerCommented:
0
 
sam15Author Commented:
Great Link. After I use the procedure dump_clob to store the HTML, I need to display a URL that displays the page. is there a procedure download_html or download_clob for that?
0
 
schwertnerCommented:
You can keep the URL in a separate column in the table you store the HTML.
Under the same primary key. You do not need CLOB to store the URL.
The VARCHAR2 data can store up to 4000 bytes that is enough.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
sam15Author Commented:
Yes, I will store the URL in same table. But the URL needs to download the HTML file stored in CLOB to the browser. My application uses MOD_PLSQL.

I think it would be similar to this except the download here use BLOB field

http://www.oracle-base.com/articles/9i/FileUploadDownloadProcedures9i.php

0
 
schwertnerCommented:
BLOBs are used because possibly the HTML paga contains some noncharacter components (like pictures).
0
 
sam15Author Commented:
No, I think it is  because MOD_PLSQL only supports file upload/downloads for BLOBS only.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now