Solved

StoriingStaticHTMLReport

Posted on 2011-02-22
6
264 Views
Last Modified: 2012-05-11
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
Comment
Question by:sam15
  • 3
  • 3
6 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 34959502
0
 

Author Comment

by:sam15
ID: 34990011
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
 
LVL 47

Expert Comment

by:schwertner
ID: 34992087
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:sam15
ID: 34992263
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
 
LVL 47

Expert Comment

by:schwertner
ID: 35010665
BLOBs are used because possibly the HTML paga contains some noncharacter components (like pictures).
0
 

Author Comment

by:sam15
ID: 35014304
No, I think it is  because MOD_PLSQL only supports file upload/downloads for BLOBS only.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now