Re: Converting SQLPLUS output to HTML

Hi,

I've used HTP.PRINT to wrap PLSQL extracts of data around HTML commands. It looks just like any PLSQL procedure but all lines of output are actual HTML strings with the relevant tabs. You lose the SQL*Plus SUM, AVG etc functions and so forth, so this may not be ideal for you!

When I provided such a solution for a complex set of reports, I used choices made by users to determine which types of reports are generated, and the URL displayed all the relevant pages after calling the relavant stored procedure through OSA.

But I can't find it on my Oracle 8i installation for Win98.

My question to anyone else responding to this is:

Has something replaced HTP.PRINT from Oracle 7? Is there some SQL installation I have to perform as SYS on my Oracle8i for Win98?
How do you go about doing the same thing as I described above in Oracle 8i?

Thanks
stevev

billmil_at_my-deja.com wrote:

>Does anyone know of a utility that can convert the sqlplus output into
>HTML?
>
>I put together, in SQLPLUS, a report that summarizes our business'
>daily activity. A shell script emails it out each day; people view it
>in their various email clients. It's proved handy and helpful. Users
>are happy with it.
>
>The problem: as the business develops, users request more info (i.e.
>more columns). The problem: more columns means wider lines which makes
>for line wrap, especially if people use laptops to view their email.
>
>It seemed that since most email clients can handle HTML, an HTML
>version of this report would allow more columns without line wrap
>problems.
>
>One more thought: I could generate the HTML directly (i.e.
>select '<TD>' || nbrLogins || '</TD>' ....), but then I'd lose the
>handy sqlplus summary function (sum,avg,std), etc.
>
>Any suggestions?
>
>thanks,
>
>bill milbratz
>chicago IL usa
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
  Received on Sat Sep 02 2000 - 04:07:13 CEST