Re: PL/SQL Package for generating HTML Tables

Christian,

have a look at the owa_util.cellsprint procedure. Should have been installed at the same time as the htp and htf packages.

The results aren't very pretty but it should do what you want.

--
Paul Dixon
paul.gp.dixon_at_tinnedham.bt.com
(Remove canned meat to reply)

"Christian Stauffer" <stauffer_at_infosystem.ch> wrote in message
news:3d188110$0$24062$7402020d_at_newsfeed.sunrise.ch...


> 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?

>

> Please send a copy of your reply to

> stauffer<at>infosystem.ch

>

> Thanks, Christian

>

> --

> Christian Stauffer

> Infosystem AG Switzerland

>

>

>