Re: generate html report using sqlplus

From: <fitzjarrell_at_cox.net>
Date: Wed, 23 Jan 2008 08:19:54 -0800 (PST)
Message-ID: <718524ad-c24e-4b34-892c-71e0ef6baae2@y5g2000hsf.googlegroups.com>


On Jan 23, 7:50 am, mak..._at_gmail.com wrote:
> On Jan 17, 11:53 pm, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
>
>
>
> > Using sqlplus, and if u have access to the htp and htf package, it
> > should be no problem generating HTML, for example, look at the file
> > $ORACLE_HOME/rdbms/admin/privutil.sql, and search for all the htp.*
> > function usage, and u can get the idea how it uses htp functions to
> > generate HTML structure contents.
>
> > For example:
>
> >      htp.preOpen;
> >          htp.prints(translate(text,NL_CHAR,' '));
> >       htp.preClose;
>
> > And this:
>
> >          htp.print('</PRE>');
> >            htp.p(htf.format_cell(columnValue, format_numbers));
> >                     htp.tableRowOpen;
> >                     htp.tableRowClose;
> >                htp.tableRowOpen;
> >                htp.tableRowClose;
> >             htp.formSelectOpen( cname => p_cname,
> >                   htp.formSelectOption( cvalue => nc_visible,
> >             htp.formSelectClose;
>
> > etc.
>
> Thanks for the valuable tips..
> where will htp.print will print? On screen? I would like to generate
> the report on client side as I don't have access to server...- Hide quoted text -
>
> - Show quoted text -

Most likely on the server, as that is where Oracle DIRECTORY objects are defined and I doubt that you have an NFS mount from the db server to the client.

David Fitzjarrell Received on Wed Jan 23 2008 - 10:19:54 CST

Original text of this message