Re: Storing HTML pages in Oracle

From: <mgogala_at_rocketmail.com>
Date: 1998/03/05
Message-ID: <6dmhat$s3q$1@nnrp1.dejanews.com>#1/1

Oracle has the tool named Web Publishing Assistant which automaticaly regenerates web pages (HTML files) as the database changes. To view these files from within oracle, define them as a column of type BFILE. BFILE columns are read-only and cannot be modified by use of PL/SQL. They can, however, be viewed through DBMS_LOB package. It's all described in the application developers guide.
Web Publishing Assistant comes with the database. It is a packaged tool that doesn't need to be purchased separately. I find it extremely useful. Mladen Gogala
In article <6dhp1r$nue$1_at_news1.fast.net>, mzawadzki_at_starnet.lenfest.com wrote:
>
> Use SQL*PLUS with correct settings and spool.
> I can even see using the 'title' to enforce a page ...
> eg . TTITLE CENTER '<HEAD>....&BEGDATE</HTML>'
> any way consult your SQL*PLUS docs
>
> Minimumly you would use:
>
> REM no column headers
> set head off
> REM no page breaks
> set pagesize 0
> REM very long lines allowed
> set linesize 9999
> REM suppress console output
> set termout off
> REM get rid of 1 row selected and the like
> set feedback off
> REM make sure SQL*PLUS doesn't have trouble with &
> set verify off
> REM make sure we don't see the select statement in the spool file
> set echo off
> REM trim whitespace at end of each line
> set trimspool on
> spool 'yourfile.html'
> select ....;
> spool off
>
> Anatolii Belomestnov <abelomestnov_at_snet.net> wrote:
>
> >Robin,

> >A good option is using Perl5 with DBI,DBD::Oracle installed.
> >you can easily pull your HTML out of the Oracle Tables and
> >put them into files. Refer to perl.org for Perl info.

> >Oh, by the way you can also use FILE_UTIL package on Oracle to create
> >files. That way could be just perfect too.

> >Anatolii

> >Robin Reese wrote:
> >>
> >> I'm storing HTML pages in Oracle, 1 row = 1 line in an HTML file. I'm
> >> creating the table using stored procedures.
> >>
> >> My problem is how to extract the pages from Oracle back to an HTML file
> >> (ie no headings etc). Also I will be replacing about 100 pages each
> >> night and I would like be able to store each HTML separately.
> >>
> >> What I would like to do is select all pages and write to a flat file.
> >> When the key changes I want the flat file name to change too.
> >>
> >> Is this possible? Is there an easier way to do this?
> >>
> >> Thanks,
> >> Robin

> >--

> >---------------------------------------------------------
> >Anatolii Belomestnov <anatolii.belomestnov_at_gecapital.com>
> >---------------------------------------------------------
>
> Mark Zawadzki, late of Waynesboro, Va.
> '...there is not a sprig of grass that shoots uninteresting to me.'
> Thomas Jefferson, 1790.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 05 1998 - 00:00:00 CST