Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying the PL/SQL web toolkit
On Fri, 17 Feb 2006 15:45:32 +0000, Jeremy wrote:
> As has been noted on here a couple of times, if you want to use the web
> plsql toolkit to generate xhtml-compliant tags (e.g. all lower case)
> then one option is to copy the HTP and HTF packages and edit these (the
> source is not wrapped).
>
> Has anyone actually done this and are there any gotchas involved?
Jeremy, HTP and HTF packages are normal, non-wrapped packages owned by SYS. They're using the same tactics as DBMS_OUTPUT: putting things into "output arrays" defined like this:
/* TYPES FOR htp.print */
-- PL/SQL table used for output buffering
HTBUF_LEN number := 255;
type htbuf_arr is table of varchar2(256) index by binary_integer;
type htraw_arr is table of raw(256) index by binary_integer;
and then displaying things by using DBMS_OUTPUT. There is nothing special about sys.htp and sys.htf. You are welcome to extract the source code, modify it as it pleases you, and then install somewhere else (not in the SYS schema). Oracle even provides you a convenient tool to extract that source code: DBMS_METADATA.GET_DDL.
-- http://www.mgogala.comReceived on Sat Feb 18 2006 - 21:37:07 CST