Re: PL/SQL Package for generating HTML Tables

On Tue, 25 Jun 2002, stauffer_at_infosystem.ch wrote:
> Hi,
>
> I saw the htp/htf packages of oracle. What I need is a
> function that returns full formatted HTML Code when I pass a
> select statement.
> Something like:
> ret:=sys.xyz.BuildHTMLTable ('select 1,2 from dual union all
> select 10,20 from dual');
> would return the HTML Code for a Table looking like:
> 1 2
> 10 20
>
> Is there an Oracle delivered package for such operations, or
> for anything else HTML-oriented?

Oracle has a boatload of XML related packages. Maybe you can have Oracle return XML and then have Oracle transform it to HTML through its xslt engine?

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a86030/toc.htm

> Please send a copy of your reply to
> stauffer<at>infosystem.ch

Come on. Read the newsgroup.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.