From yuzhu@postoffice.npac.syr.edu Wed Nov 12 17:00 EST 1997
Received: from scorpio.npac.syr.edu (scorpio.npac.syr.edu [128.230.14.16]) by postoffice.npac.syr.edu (8.7.5/8.7.1) with ESMTP id RAA28418 for <msen7@npac.syr.edu>; Wed, 12 Nov 1997 17:00:36 -0500 (EST)
Received: from osprey2.npac.syr.edu (osprey2.npac.syr.edu [128.230.164.132]) by scorpio.npac.syr.edu (8.7.5/8.7.1) with SMTP id QAA05769 for <msen7>; Wed, 12 Nov 1997 16:54:13 -0500 (EST)
Sender: yuzhu@npac.syr.edu
Message-ID: <346A26FB.370A@npac.syr.edu>
Date: Wed, 12 Nov 1997 17:00:27 -0500
From: Yuping Zhu <yuzhu@npac.syr.edu>
X-Mailer: Mozilla 3.0 (X11; I; SunOS 5.5.1 sun4u)
MIME-Version: 1.0
To: msen7@scorpio.npac.syr.edu
Subject: Source code for HTF
Content-Type: multipart/mixed; boundary="------------56483510231C"
Content-Length: 59901
X-Status: A
Status: ROr

This is a multi-part message in MIME format.

--------------56483510231C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

http://osprey7:8888/owa_dba/owa/browse.show_source?cname=GRID1.HTF

--------------56483510231C
Content-Type: text/html; charset=us-ascii; name="browse.show_source"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="browse.show_source"
Content-Base: "http://osprey7:8888/owa_dba/owa/browse
	.show_source?cname=GRID1.HTF"

<BASE HREF="http://osprey7:8888/owa_dba/owa/browse.show_source?cname=GRID1.HTF">

<TITLE>Source code for HTF</TITLE>
<H1>Source code for HTF</H1>
<PRE>
package htf as 
 
/* STRUCTURE tags */ 
/*function*/ htmlOpen          constant varchar2(7) := '&lt;HTML&gt;'; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
/*function*/ htmlClose         constant varchar2(7) := '&lt;/HTML&gt;'; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
/*function*/ headOpen          constant varchar2(7) := '&lt;HEAD&gt;'; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
/*function*/ headClose         constant varchar2(7) := '&lt;/HEAD&gt;'; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
function     bodyOpen (cbackground in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function*/ bodyClose         constant varchar2(7) := '&lt;/BODY&gt;'; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
/* END STRUCTURE tags */ 
 
/* HEAD Related elements tags */ 
function title(ctitle in varchar2) return varchar2; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
function htitle(ctitle      in varchar2, 
                nsize       in integer  DEFAULT 1, 
                calign      in varchar2 DEFAULT NULL, 
                cnowrap     in varchar2 DEFAULT NULL, 
                cclear      in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function base(	ctarget in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function isindex(cprompt in varchar2 DEFAULT NULL, 
                 curl    in varchar2 DEFAULT NULL) return varchar2; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
function linkRel(crel   in varchar2,  
                 curl   in varchar2,  
                 ctitle in varchar2 DEFAULT NULL) return varchar2; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
function linkRev(crev   in varchar2, 
                 curl   in varchar2,  
                 ctitle in varchar2 DEFAULT NULL) return varchar2; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
function meta(chttp_equiv in varchar2, 
              cname       in varchar2, 
              ccontent    in varchar2) return varchar2; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
function nextid(cidentifier in varchar2) return varchar2; 
         /* No attributes in HTML 3.0 spec as of 6/7/95 */ 
/* END HEAD Related elements tags */ 
 
/* BODY ELEMENT tags */ 
function hr  (cclear      in varchar2 DEFAULT NULL, 
              csrc        in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL) return varchar2; 
function line(cclear      in varchar2 DEFAULT NULL, 
              csrc        in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL) return varchar2; 
function br(cclear      in varchar2 DEFAULT NULL, 
            cattributes in varchar2 DEFAULT NULL) return varchar2; 
function nl(cclear      in varchar2 DEFAULT NULL, 
            cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function header(nsize       in integer, 
                cheader     in varchar2, 
                calign      in varchar2 DEFAULT NULL, 
                cnowrap     in varchar2 DEFAULT NULL, 
                cclear      in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function anchor(curl        in varchar2, 
                ctext       in varchar2, 
                cname       in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function anchor2(curl        in varchar2, 
                ctext       in varchar2, 
                cname       in varchar2 DEFAULT NULL, 
		ctarget	    in varchar2 DEFAULT NULL,  
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function mailto(caddress    in varchar2, 
                ctext       in varchar2, 
                cname       in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function img(curl        in varchar2, 
             calign      in varchar2 DEFAULT NULL, 
             calt        in varchar2 DEFAULT NULL, 
             cismap      in varchar2 DEFAULT NULL, 
             cattributes in varchar2 DEFAULT NULL) return varchar2; 
function img2(curl        in varchar2, 
             calign      in varchar2 DEFAULT NULL, 
             calt        in varchar2 DEFAULT NULL, 
             cismap      in varchar2 DEFAULT NULL, 
 	     cusemap     in varchar2 DEFAULT NULL, 
             cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function area(	ccoords	in varchar2, 
             	cshape	in varchar2 DEFAULT NULL, 
             	chref	in varchar2 DEFAULT NULL, 
             	cnohref	in varchar2 DEFAULT NULL, 
		ctarget in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function mapOpen(cname	in varchar2, 
		 cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function*/ mapClose	constant varchar2(6) := '&lt;/MAP&gt;'; 
 
function bgsound(csrc	in varchar2, 
		 cloop 	in varchar2 DEFAULT NULL, 
		 cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
 
/*function*/ para              constant varchar2(3) := '&lt;P&gt;'; 
function paragraph(calign       in varchar2 DEFAULT NULL, 
                   cnowrap      in varchar2 DEFAULT NULL, 
                   cclear       in varchar2 DEFAULT NULL, 
                   cattributes  in varchar2 DEFAULT NULL) return varchar2; 
function div(	calign       in varchar2 DEFAULT NULL, 
                cattributes  in varchar2 DEFAULT NULL) return varchar2; 
function address(cvalue       in varchar2, 
                 cnowrap      in varchar2 DEFAULT NULL, 
                 cclear       in varchar2 DEFAULT NULL, 
                 cattributes  in varchar2 DEFAULT NULL) return varchar2; 
function comment(ctext in varchar2) return varchar2; 
function preOpen(cclear      in varchar2 DEFAULT NULL, 
                 cwidth      in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function*/ preClose          constant varchar2(6) := '&lt;/PRE&gt;'; 
/*function*/ listingOpen	constant varchar2(9) := '&lt;LISTING&gt;'; 
/*function*/ listingClose	constant varchar2(10) := '&lt;/LISTING&gt;'; 
 
function nobr(ctext in varchar2) return varchar2; 
/*function*/ wbr constant varchar(5) := '&lt;WBR&gt;'; 
 
function center(ctext in varchar2) return varchar2; 
/*function*/ centerOpen	constant varchar2(8) := '&lt;CENTER&gt;'; 
/*function*/ centerClose constant varchar2(9) := '&lt;/CENTER&gt;'; 
 
function blockquoteOpen(cnowrap      in varchar2 DEFAULT NULL, 
                        cclear       in varchar2 DEFAULT NULL, 
                        cattributes  in varchar2 DEFAULT NULL) return varchar2; 
/*function*/ blockquoteClose   constant varchar2(13) := '&lt;/BLOCKQUOTE&gt;'; 
 
/* LIST tags */ 
function listHeader(ctext in varchar2, 
                    cattributes in varchar2 DEFAULT NULL) return varchar2; 
function listItem(ctext       in varchar2 DEFAULT NULL, 
                  cclear      in varchar2 DEFAULT NULL, 
                  cdingbat    in varchar2 DEFAULT NULL, 
                  csrc        in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
function ulistOpen(cclear      in varchar2 DEFAULT NULL, 
                   cwrap       in varchar2 DEFAULT NULL, 
                   cdingbat    in varchar2 DEFAULT NULL, 
                   csrc        in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function */ ulistClose        constant varchar2(5) := '&lt;/UL&gt;'; 
function olistOpen(cclear      in varchar2 DEFAULT NULL, 
                   cwrap       in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function */ olistClose        constant varchar2(5) := '&lt;/OL&gt;'; 
function dlistOpen(cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function dlistTerm(ctext       in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function dlistDef(ctext       in varchar2 DEFAULT NULL, 
                  cclear      in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function */ dlistClose        constant varchar2(5) := '&lt;/DL&gt;'; 
 
/*function */ menulistOpen      constant varchar2(6) := '&lt;MENU&gt;'; 
/*function */ menulistClose     constant varchar2(7) := '&lt;/MENU&gt;'; 
 
/*function */ dirlistOpen       constant varchar2(5) := '&lt;DIR&gt;'; 
/*function */ dirlistClose      constant varchar2(6) := '&lt;/DIR&gt;'; 
/* END LIST tags */ 
 
 
/* SEMANTIC FORMAT ELEMENTS */ 
function dfn(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2; 
function cite(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2; 
function code(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2; 
function em(ctext in varchar2, 
            cattributes in varchar2 DEFAULT NULL) return varchar2; 
function emphasis(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
function keyboard(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
function kbd(ctext in varchar2, 
             cattributes in varchar2 DEFAULT NULL) return varchar2; 
function sample(ctext in varchar2, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function strong(ctext in varchar2, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function variable(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
function big(	ctext 		in varchar2, 
		cattributes 	in varchar2 DEFAULT NULL) return varchar2; 
function small(	ctext 		in varchar2, 
		cattributes 	in varchar2 DEFAULT NULL) return varchar2; 
function sub(	ctext 		in varchar2, 
		calign 		in varchar2 DEFAULT NULL, 
		cattributes 	in varchar2 DEFAULT NULL) return varchar2; 
function sup(	ctext 		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) return varchar2; 
/* END SEMANTIC FORMAT ELEMENTS */ 
 
/* PHYSICAL FORMAT ELEMENTS */ 
function basefont(	nsize in integer, 
			cattributes in varchar2 DEFAULT NULL) return varchar2; 
function fontOpen(	ccolor 	in varchar2 DEFAULT NULL, 
		cface	in varchar2 DEFAULT NULL, 
		csize	in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function*/ fontClose	constant varchar2(7) := '&lt;/FONT&gt;'; 
function bold(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2; 
function italic(ctext in varchar2, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
function teletype(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
function plaintext(ctext in varchar2, 
              	   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function s(ctext in varchar2, 
           cattributes in varchar2 DEFAULT NULL) return varchar2; 
function strike(ctext in varchar2, 
                cattributes in varchar2 DEFAULT NULL) return varchar2; 
/* END PHYSICAL FORMAT ELEMENTS */ 
 
/* HTML FORMS */ 
function formOpen(curl     in varchar2, 
                  cmethod  in varchar2 DEFAULT 'POST', 
		  ctarget  in varchar2 DEFAULT NULL, 
		  cenctype in varchar2 DEFAULT NULL, 
		  cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function formCheckbox(cname       in varchar2, 
                      cvalue      in varchar2 DEFAULT 'on', 
                      cchecked    in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formHidden(cname       in varchar2, 
                    cvalue      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formImage(cname       in varchar2, 
                   csrc        in varchar2, 
                   calign      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formPassword(cname       in varchar2, 
                      csize       in varchar2 DEFAULT NULL, 
                      cmaxlength  in varchar2 DEFAULT NULL, 
                      cvalue      in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formRadio(cname       in varchar2, 
                   cvalue      in varchar2, 
                   cchecked    in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formReset(cvalue      in varchar2 DEFAULT 'Reset', 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formSubmit(cname       in varchar2 DEFAULT NULL, 
                    cvalue      in varchar2 DEFAULT 'Submit', 
                    cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formText(cname       in varchar2, 
                  csize       in varchar2 DEFAULT NULL, 
                  cmaxlength  in varchar2 DEFAULT NULL, 
                  cvalue      in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function formSelectOpen(cname       in varchar2, 
                        cprompt     in varchar2 DEFAULT NULL, 
                        nsize       in integer  DEFAULT NULL, 
                        cattributes in varchar2 DEFAULT NULL) return varchar2; 
function formSelectOption(cvalue      in varchar2, 
                          cselected   in varchar2 DEFAULT NULL, 
                          cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function */ formSelectClose   constant varchar2(9) := '&lt;/SELECT&gt;'; 
 
function formTextarea(cname       in varchar2, 
                      nrows       in integer, 
                      ncolumns    in integer, 
                      calign      in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2;  
 
function formTextarea2(cname       in varchar2, 
                      nrows       in integer, 
                      ncolumns    in integer, 
                      calign      in varchar2 DEFAULT NULL, 
                      cwrap       in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2;  
 
function formTextareaOpen(cname       in varchar2, 
                          nrows       in integer, 
                          ncolumns    in integer, 
                          calign      in varchar2 DEFAULT NULL, 
                          cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
function formTextareaOpen2(cname       in varchar2, 
                          nrows       in integer, 
                          ncolumns    in integer, 
                          calign      in varchar2 DEFAULT NULL, 
                          cwrap       in varchar2 DEFAULT NULL, 
                          cattributes in varchar2 DEFAULT NULL) return varchar2; 
 
/*function */ formTextareaClose constant varchar2(11) := '&lt;/TEXTAREA&gt;'; 
 
/*function */ formClose         constant varchar2(7) := '&lt;/FORM&gt;'; 
/* END HTML FORMS */  
 
 
/* HTML TABLES */ 
function tableOpen(cborder     in varchar2 DEFAULT NULL, 
                   calign      in varchar2 DEFAULT NULL, 
                   cnowrap     in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
function tableCaption(ccaption    in varchar2, 
                      calign      in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2; 
function tableRowOpen(calign      in varchar2 DEFAULT NULL, 
                      cvalign     in varchar2 DEFAULT NULL, 
                      cdp         in varchar2 DEFAULT NULL, 
                      cnowrap     in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2; 
function tableHeader(cvalue      in varchar2 DEFAULT NULL, 
                     calign      in varchar2 DEFAULT NULL, 
                     cdp         in varchar2 DEFAULT NULL, 
                     cnowrap     in varchar2 DEFAULT NULL, 
                     crowspan    in varchar2 DEFAULT NULL, 
                     ccolspan    in varchar2 DEFAULT NULL, 
                     cattributes in varchar2 DEFAULT NULL) return varchar2; 
function tableData(cvalue      in varchar2 DEFAULT NULL, 
                   calign      in varchar2 DEFAULT NULL, 
                   cdp         in varchar2 DEFAULT NULL, 
                   cnowrap     in varchar2 DEFAULT NULL, 
                   crowspan    in varchar2 DEFAULT NULL, 
                   ccolspan    in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2; 
/*function */ tableRowClose constant varchar2(5) := '&lt;/TR&gt;'; 
 
/*function */ tableClose    constant varchar2(8) := '&lt;/TABLE&gt;'; 
/* END HTML TABLES */ 
 
/* HTML FRAMES */ 
 
function framesetOpen(	crows	in varchar2 DEFAULT NULL,	/* row heigh value list */ 
			ccols 	in varchar2 DEFAULT NULL, 
			cattributes in varchar2 DEFAULT NULL) return varchar2;	/* column width list */ 
 
/* function */ framesetClose 	constant varchar2(11) := '&lt;/FRAMESET&gt;'; 
 
function frame(		csrc	in varchar2,				/* URL */ 
			cname	in varchar2 DEFAULT NULL,		/* Window Name */ 
			cmarginwidth 	in varchar2 DEFAULT NULL,	/* Value in pixels */ 
			cmarginheight	in varchar2 DEFAULT NULL,	/* Value in pixels */ 
			cscrolling	in varchar2 DEFAULT NULL,	/* yes | no | auto */ 
			cnoresize	in varchar2 DEFAULT NULL, 
			cattributes	in varchar2 DEFAULT NULL) return varchar2;	/* Not resizable by user */ 
 
/* function */ noframesOpen	constant varchar2(10) := '&lt;NOFRAMES&gt;'; 
/* function */ noframesClose	constant varchar2(11) := '&lt;/NOFRAMES&gt;'; 
/* END HTML FRAMES */ 
 
/* SPECIAL FUNCTIONS */ 
function escape_sc(ctext in varchar2) return varchar2; 
/* END SPECIAL FUNCTIONS */ 
 
/* END BODY ELEMENT tags */ 
 
/* Assert function purities so that they can be used in select lists */ 
PRAGMA RESTRICT_REFERENCES(bodyOpen,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(title,            WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(htitle,           WNDS, WNPS, RNDS, RNPS); 
-- PRAGMA RESTRICT_REFERENCES(base,             WNDS, WNPS, RNDS); 
PRAGMA RESTRICT_REFERENCES(isindex,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(linkRel,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(linkRev,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(meta,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(nextid,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(hr,               WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(line,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(br,               WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(nl,               WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(header,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(img,              WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(img2,              WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(mapOpen,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(area,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(bgsound,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(paragraph,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(div,        	    WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(address,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(comment,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(preOpen,          WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(nobr,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(center,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(blockquoteOpen,   WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(listHeader,       WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(listItem,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(ulistOpen,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(olistOpen,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(dlistOpen,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(dlistTerm,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(dlistDef,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(cite,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(dfn,              WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(code,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(em,               WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(emphasis,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(keyboard,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(kbd,              WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(sample,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(strong,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(variable,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(big,         	    WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(small,            WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(sub,              WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(sup,              WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(basefont,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(fontOpen,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(bold,             WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(italic,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(teletype,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(plaintext,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(strike,           WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(s,                WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formOpen,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formCheckbox,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formHidden,       WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formImage,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formPassword,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formRadio,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formReset,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formSubmit,       WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formText,         WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formSelectOpen,   WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formSelectOption, WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formTextarea,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formTextarea2,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formTextareaOpen, WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(formTextareaOpen2, WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(tableOpen,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(tableCaption,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(tableRowOpen,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(tableHeader,      WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(tableData,        WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(framesetOpen,     WNDS, WNPS, RNDS, RNPS); 
PRAGMA RESTRICT_REFERENCES(frame,            WNDS, WNPS, RNDS, RNPS); 
 
PRAGMA RESTRICT_REFERENCES(escape_sc,        WNDS, WNPS, RNDS, RNPS); 
 
end; 

package body htf as 
 
/* This function is private to the HTF package */ 
function IFNOTNULL(str1 in varchar2, str2 in varchar2) return varchar2 is 
begin 
   if (str1 is NULL) 
     then return (NULL); 
     else return (str2); 
   end if; 
end; 
 
/* STRUCTURE tags */ 
function bodyOpen(cbackground in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;BODY'|| 
              IFNOTNULL(cbackground,' BACKGROUND=&quot;'||cbackground||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
/* END STRUCTURE tags */ 
 
/* HEAD Related elements tags */ 
function title  (ctitle in varchar2) return varchar2 is 
begin return ('&lt;TITLE&gt;'||ctitle||'&lt;/TITLE&gt;'); end; 
 
function htitle(ctitle      in varchar2, 
                nsize       in integer  DEFAULT 1, 
                calign      in varchar2 DEFAULT NULL, 
                cnowrap     in varchar2 DEFAULT NULL, 
                cclear      in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return (title(ctitle)|| 
              header(nsize,ctitle,calign,cnowrap,cclear,cattributes)); end; 
 
function base(	ctarget 	in varchar2 DEFAULT NULL, 
		cattributes 	in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;BASE'|| 
		IFNOTNULL(ctarget,' TARGET=&quot;'||ctarget||'&quot;')|| 
              	IFNOTNULL(cattributes,' '||cattributes)|| 
		' HREF=&quot;http://'||owa_util.get_cgi_env('SERVER_NAME')||':'|| 
                                    owa_util.get_cgi_env('SERVER_PORT')|| 
                                    owa_util.get_cgi_env('SCRIPT_NAME')|| 
                                    owa_util.get_cgi_env('PATH_INFO')||'&quot;&gt;'); 
end; 
 
function isindex(cprompt in varchar2 DEFAULT NULL, 
                 curl    in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;ISINDEX'|| 
              IFNOTNULL(cprompt,' PROMPT=&quot;'||cprompt||'&quot;')|| 
              IFNOTNULL(curl,' HREF=&quot;'||curl||'&quot;')|| 
             '&gt;'); end; 
 
function linkRel(crel   in varchar2,  
                 curl   in varchar2,  
                 ctitle in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;LINK REL=&quot;'||crel||'&quot;'|| 
                  ' HREF=&quot;'||curl||'&quot;'|| 
               IFNOTNULL(ctitle,' TITLE=&quot;'||ctitle||'&quot;')|| 
             '&gt;'); end; 
 
function linkRev(crev   in varchar2,  
                 curl   in varchar2,  
                 ctitle in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;LINK REV=&quot;'||crev||'&quot;'|| 
                  ' HREF=&quot;'||curl||'&quot;'|| 
               IFNOTNULL(ctitle,' TITLE=&quot;'||ctitle||'&quot;')|| 
             '&gt;'); end; 
 
function meta(chttp_equiv in varchar2, 
              cname       in varchar2, 
              ccontent    in varchar2) return varchar2 is 
begin return('&lt;META HTTP-EQUIV=&quot;'||chttp_equiv|| 
                       '&quot; NAME=&quot;'||cname|| 
                    '&quot; CONTENT=&quot;'||ccontent|| 
                    '&quot;&gt;'); 
end; 
 
function nextid(cidentifier in varchar2) return varchar2 is 
begin return ('&lt;NEXTID N=&quot;'||cidentifier||'&gt;'); end; 
 
/* END HEAD Related elements tags */ 
 
/* BODY ELEMENT tags */ 
function hr  (cclear      in varchar2 DEFAULT NULL, 
              csrc        in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;HR'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(csrc,' SRC=&quot;'||csrc||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function line(cclear      in varchar2 DEFAULT NULL, 
              csrc        in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return(hr(cclear, csrc, cattributes)); end; 
 
function br(cclear      in varchar2 DEFAULT NULL, 
            cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;BR'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function nl(cclear      in varchar2 DEFAULT NULL, 
            cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return(br(cclear, cattributes)); end; 
 
function header(nsize   in integer, 
                cheader in varchar2, 
                calign  in varchar2 DEFAULT NULL, 
                cnowrap in varchar2 DEFAULT NULL, 
                cclear  in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2 is 
	ch varchar2(2); 
begin 
	ch := 'H'||to_char(least(abs(nsize),6)); 
	return('&lt;'||ch|| 
                IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
                IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
                IFNOTNULL(cnowrap,' NOWRAP')|| 
                IFNOTNULL(cattributes,' '||cattributes)|| 
               '&gt;'||cheader|| 
               '&lt;/'||ch||'&gt;'); 
end; 
 
function anchor(curl        in varchar2, 
                ctext       in varchar2, 
                cname       in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return(	anchor2(curl, 
			ctext, 
			cname, 
			NULL, 
			cattributes)); 
end; 
 
function anchor2(curl       in varchar2, 
                ctext       in varchar2, 
                cname       in varchar2 DEFAULT NULL, 
		ctarget	    in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2 is 
	curl_cname_null EXCEPTION; 
begin  
	if curl is NULL and cname is NULL then 
		RAISE curl_cname_null; 
	end if; 
	 
	if curl is NULL then 
		return('&lt;A NAME=&quot;'||cname||'&quot;'|| 
 			IFNOTNULL(ctext,'&gt; '||ctext||' &lt;/A')|| 
                       '&gt;'); 
	else 
		return('&lt;A HREF=&quot;'||curl||'&quot;'|| 
        	       	IFNOTNULL(cname,' NAME=&quot;'||cname||'&quot;')|| 
			IFNOTNULL(ctarget,' TARGET=&quot;'||ctarget||'&quot;')|| 
               		IFNOTNULL(cattributes,' '||cattributes)|| 
              		'&gt;'||ctext|| 
              		'&lt;/A&gt;'); 
	end if; 
exception 
	when curl_cname_null then 
		raise_application_error(-20001,  
			'curl and cname cannot be NULL'); 
end; 
 
 
function mailto(caddress in varchar2, 
                ctext    in varchar2, 
                cname       in varchar2 DEFAULT NULL, 
                cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return (anchor('mailto:'||caddress,ctext,cname,cattributes)); end; 
 
function img(curl        in varchar2, 
             calign      in varchar2 DEFAULT NULL, 
             calt        in varchar2 DEFAULT NULL, 
             cismap      in varchar2 DEFAULT NULL, 
             cattributes in varchar2 DEFAULT NULL 
             ) return varchar2 is 
begin return('&lt;IMG SRC=&quot;'||curl||'&quot;'|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(calt,' ALT=&quot;'||calt||'&quot;')|| 
               IFNOTNULL(cismap,' ISMAP')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
function img2(curl        in varchar2, 
             calign      in varchar2 DEFAULT NULL, 
             calt        in varchar2 DEFAULT NULL, 
             cismap      in varchar2 DEFAULT NULL, 
             cusemap     in varchar2 DEFAULT NULL, 
             cattributes in varchar2 DEFAULT NULL 
             ) return varchar2 is 
begin return('&lt;IMG SRC=&quot;'||curl||'&quot;'|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(calt,' ALT=&quot;'||calt||'&quot;')|| 
               IFNOTNULL(cismap,' ISMAP')|| 
               IFNOTNULL(cusemap,' USEMAP=&quot;'||cusemap||'&quot;')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
 
function area(	ccoords	in varchar2, 
             	cshape	in varchar2 DEFAULT NULL, 
             	chref	in varchar2 DEFAULT NULL, 
             	cnohref	in varchar2 DEFAULT NULL, 
		ctarget in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;AREA'|| 
		IFNOTNULL(cshape,' SHAPE=&quot;'||cshape||'&quot;')|| 
		' COORDS=&quot;'||ccoords||'&quot;'|| 
                IFNOTNULL(chref,' HREF=&quot;'||chref||'&quot;')|| 
                IFNOTNULL(cnohref,' NOHREF')|| 
                IFNOTNULL(ctarget,' CTARGET=&quot;'||ctarget||'&quot;')|| 
		IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
function mapOpen(cname	in varchar2,cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;MAP NAME=&quot;'||cname||'&quot;'|| 
		IFNOTNULL(cattributes,' '||cattributes)|| 
		'&gt;'); end; 
 
function bgsound(csrc	in varchar2, 
		 cloop	in varchar2 DEFAULT NULL, 
		 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;BGSOUND SRC=&quot;'||csrc||'&quot;'|| 
		IFNOTNULL(cloop,' LOOP=&quot;'||cloop||'&quot;')|| 
		IFNOTNULL(cattributes,' '||cattributes)|| 
		'&gt;');end; 
 
 
function paragraph(calign       in varchar2 DEFAULT NULL, 
                   cnowrap      in varchar2 DEFAULT NULL, 
                   cclear       in varchar2 DEFAULT NULL, 
                   cattributes  in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;P'|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cnowrap,' NOWRAP')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function div(	calign       in varchar2 DEFAULT NULL, 
               	cattributes  in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;DIV'|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function address(cvalue       in varchar2, 
                 cnowrap      in varchar2 DEFAULT NULL, 
                 cclear       in varchar2 DEFAULT NULL, 
                 cattributes  in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;ADDRESS'|| 
               IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
               IFNOTNULL(cnowrap,' NOWRAP')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||cvalue|| 
             '&lt;/ADDRESS&gt;'); end; 
 
function comment(ctext in varchar2) return varchar2 is 
begin return('&lt;!-- '||ctext||' --&gt;'); end; 
 
function preOpen(cclear      in varchar2 DEFAULT NULL, 
                 cwidth      in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;PRE'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cwidth,' WIDTH=&quot;'||cwidth||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
function nobr(ctext in varchar2) return varchar2 is 
begin return('&lt;NOBR&gt;'||ctext||'&lt;/NOBR&gt;'); end; 
 
function center(ctext in varchar2) return varchar2 is 
begin return('&lt;CENTER&gt;'||ctext||'&lt;/CENTER&gt;'); end; 
 
 
function blockquoteOpen(cnowrap      in varchar2 DEFAULT NULL, 
                        cclear       in varchar2 DEFAULT NULL, 
                        cattributes  in varchar2 DEFAULT NULL) return varchar2 
 is 
begin return('&lt;BLOCKQUOTE'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cnowrap,' NOWRAP')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
/* LIST tags */ 
function listHeader(ctext in varchar2, 
                    cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;LH'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
            '&gt;'||ctext|| 
            '&lt;/LH&gt;'); end; 
 
function listItem(ctext       in varchar2 DEFAULT NULL, 
                  cclear      in varchar2 DEFAULT NULL, 
                  cdingbat    in varchar2 DEFAULT NULL, 
                  csrc        in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;LI'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cdingbat,' DINGBAT=&quot;'||cdingbat||'&quot;')|| 
              IFNOTNULL(csrc,' SRC=&quot;'||csrc||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext); 
end; 
 
function ulistOpen(cclear      in varchar2 DEFAULT NULL, 
                   cwrap       in varchar2 DEFAULT NULL, 
                   cdingbat    in varchar2 DEFAULT NULL, 
                   csrc        in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;UL'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cwrap,' WRAP=&quot;'||cwrap||'&quot;')|| 
              IFNOTNULL(cdingbat,' DINGBAT=&quot;'||cdingbat||'&quot;')|| 
              IFNOTNULL(csrc,' SRC=&quot;'||csrc||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function olistOpen(cclear      in varchar2 DEFAULT NULL, 
                   cwrap       in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;OL'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cwrap,' WRAP=&quot;'||cwrap||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function dlistOpen(cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;DL'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function dlistTerm(ctext       in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;DT'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext); 
end; 
 
function dlistDef(ctext       in varchar2 DEFAULT NULL, 
                  cclear      in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;DD'|| 
              IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext); 
end; 
/* END LIST tags */ 
 
/* SEMANTIC FORMAT ELEMENTS */ 
function dfn(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;DFN'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/DFN&gt;'); end; 
 
function cite(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;CITE'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/CITE&gt;'); end; 
 
function code(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;CODE'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/CODE&gt;'); end; 
 
function em   (ctext  in varchar2, 
               cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;EM'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/EM&gt;'); end; 
 
function emphasis(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return(em(ctext,cattributes)); end; 
 
function kbd(ctext in varchar2, 
             cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;KBD'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/KBD&gt;'); end; 
 
function keyboard(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return(kbd(ctext,cattributes)); end; 
 
function sample(ctext in varchar2, 
                cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;SAMP'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/SAMP&gt;'); end; 
 
function strong   (ctext  in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;STRONG'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/STRONG&gt;'); end; 
 
function variable(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;VAR'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/VAR&gt;'); end; 
 
function big(	ctext  		in varchar2, 
                cattributes 	in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;BIG'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/BIG&gt;'); end; 
 
function small(	ctext  		in varchar2, 
                cattributes 	in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;SMALL'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/SMALL&gt;'); end; 
 
function sub( 	ctext  		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
                cattributes 	in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;SUB'|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/SUB&gt;'); end; 
 
function sup(	ctext  		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
                cattributes 	in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;SUP'|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/SUP&gt;'); end; 
 
/* END SEMANTIC FORMAT ELEMENTS */ 
 
/* PHYSICAL FORMAT ELEMENTS */ 
function basefont(nsize in integer, 
		  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;BASEFONT SIZE=&quot;'||nsize||'&quot;'|| 
		IFNOTNULL(cattributes,' '||cattributes)|| 
		'&gt;'); end; 
 
 
function fontOpen(	ccolor	in varchar2 DEFAULT NULL, 
		cface	in varchar2 DEFAULT NULL, 
		csize	in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;FONT'|| 
		IFNOTNULL(ccolor,' COLOR=&quot;'||ccolor||'&quot;')|| 
		IFNOTNULL(cface,' FACE=&quot;'||cface||'&quot;')|| 
		IFNOTNULL(csize,' SIZE=&quot;'||csize||'&quot;')|| 
		IFNOTNULL(cattributes,' '||cattributes)|| 
		'&gt;');end; 
 
function bold   (ctext  in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;B'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/B&gt;'); end; 
 
function italic (ctext  in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;I'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/I&gt;'); end; 
 
function teletype(ctext in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;TT'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/TT&gt;'); end; 
 
function plaintext   (ctext  in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;PLAINTEXT'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/PLAINTEXT&gt;'); end; 
function s   (ctext  in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;S'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/S&gt;'); end; 
function strike   (ctext  in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;STRIKE'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||ctext||'&lt;/STRIKE&gt;'); end; 
/* END PHYSICAL FORMAT ELEMENTS */ 
 
 
/* HTML FORMS */ 
 
function formOpen(curl in varchar2, 
                  cmethod  in varchar2 DEFAULT 'POST', 
		  ctarget  in varchar2 DEFAULT NULL, 
		  cenctype in varchar2 DEFAULT NULL, 
		  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;FORM ACTION=&quot;'||curl||'&quot; METHOD=&quot;'||cmethod||'&quot;'|| 
		IFNOTNULL(ctarget,' TARGET=&quot;'||ctarget||'&quot;')|| 
		IFNOTNULL(cenctype,' ENCTYPE=&quot;'||cenctype||'&quot;')|| 
		IFNOTNULL(cattributes,' '||cattributes)|| 
		'&gt;'); end; 
 
function formCheckbox(cname in varchar2, 
                      cvalue      in varchar2 DEFAULT 'on', 
                      cchecked    in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin  
   return('&lt;INPUT TYPE=&quot;checkbox&quot; NAME=&quot;'||cname||'&quot;'|| 
           IFNOTNULL(cvalue,' VALUE=&quot;'||cvalue||'&quot;')|| 
           IFNOTNULL(cchecked,' CHECKED')|| 
           IFNOTNULL(cattributes,' '||cattributes)|| 
          '&gt;'); 
end; 
 
function formHidden(cname       in varchar2, 
                    cvalue      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin  
   return('&lt;INPUT TYPE=&quot;hidden&quot; NAME=&quot;'||cname||'&quot;'||' VALUE=&quot;'||cvalue||'&quot;'|| 
           IFNOTNULL(cattributes,' '||cattributes)|| 
          '&gt;');  
end; 
 
function formImage(cname       in varchar2, 
                   csrc        in varchar2, 
                   calign      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;INPUT TYPE=&quot;image&quot; NAME=&quot;'||cname||'&quot;'|| 
                                 ' SRC=&quot;'||csrc||'&quot;'|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end;  
 
function formPassword(cname       in varchar2, 
                      csize       in varchar2 DEFAULT NULL, 
                      cmaxlength  in varchar2 DEFAULT NULL, 
                      cvalue      in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin 
   return('&lt;INPUT TYPE=&quot;password&quot; NAME=&quot;'||cname||'&quot;'|| 
           IFNOTNULL(csize,' SIZE=&quot;'||csize||'&quot;')|| 
           IFNOTNULL(cmaxlength,' MAXLENGTH=&quot;'||cmaxlength||'&quot;')|| 
           IFNOTNULL(cvalue,' VALUE=&quot;'||cvalue||'&quot;')|| 
           IFNOTNULL(cattributes,' '||cattributes)|| 
          '&gt;');  
end; 
 
function formRadio(cname       in varchar2, 
                   cvalue      in varchar2, 
                   cchecked    in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;INPUT TYPE=&quot;radio&quot; NAME=&quot;'||cname||'&quot;'|| 
                               ' VALUE=&quot;'||cvalue||'&quot;'|| 
              IFNOTNULL(cchecked,' CHECKED')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
function formReset(cvalue      in varchar2 DEFAULT 'Reset', 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;INPUT TYPE=&quot;reset&quot; VALUE=&quot;'||cvalue||'&quot;'|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
function formSubmit(cname       in varchar2 DEFAULT NULL, 
                    cvalue      in varchar2 DEFAULT 'Submit', 
                    cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;INPUT TYPE=&quot;submit&quot;'|| 
              IFNOTNULL(cname,' NAME=&quot;'||cname||'&quot;')|| 
              IFNOTNULL(cvalue,' VALUE=&quot;'||cvalue||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); end; 
 
function formText(cname       in varchar2, 
                  csize       in varchar2 DEFAULT NULL, 
                  cmaxlength  in varchar2 DEFAULT NULL, 
                  cvalue      in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin 
   return('&lt;INPUT TYPE=&quot;text&quot; NAME=&quot;'||cname||'&quot;'|| 
           IFNOTNULL(csize,' SIZE=&quot;'||csize||'&quot;')|| 
           IFNOTNULL(cmaxlength,' MAXLENGTH=&quot;'||cmaxlength||'&quot;')|| 
           IFNOTNULL(cvalue,' VALUE=&quot;'||cvalue||'&quot;')|| 
           IFNOTNULL(cattributes,' '||cattributes)|| 
          '&gt;');  
end; 
 
function formSelectOpen(cname       in varchar2, 
                        cprompt     in varchar2 DEFAULT NULL, 
                        nsize       in integer  DEFAULT NULL, 
                        cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return(cprompt|| 
            '&lt;SELECT NAME=&quot;'||cname||'&quot;'|| 
             IFNOTNULL(nsize,' SIZE=&quot;'||nsize||'&quot;')|| 
             IFNOTNULL(cattributes,' '||cattributes)|| 
            '&gt;'); 
end; 
 
function formSelectOption(cvalue      in varchar2, 
                          cselected   in varchar2 DEFAULT NULL, 
                          cattributes in varchar2) return varchar2 is  
begin return('&lt;OPTION'|| 
              IFNOTNULL(cselected,' SELECTED')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'||cvalue); end; 
 
function formTextarea(cname       in varchar2, 
                      nrows       in integer, 
                      ncolumns    in integer, 
                      calign      in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;TEXTAREA NAME=&quot;'||cname||'&quot;'|| 
                      ' ROWS='||to_char(nrows)|| 
                      ' COLS='||to_char(ncolumns)|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;&lt;/TEXTAREA&gt;'); 
end; 
 
 
function formTextarea2(cname       in varchar2, 
                      nrows       in integer, 
                      ncolumns    in integer, 
                      calign      in varchar2 DEFAULT NULL, 
                      cwrap       in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return('&lt;TEXTAREA NAME=&quot;'||cname||'&quot;'|| 
                      ' ROWS='||to_char(nrows)|| 
                      ' COLS='||to_char(ncolumns)|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cwrap,' WRAP=&quot;'||cwrap||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;&lt;/TEXTAREA&gt;'); 
end; 
 
function formTextareaOpen(cname       in varchar2, 
                          nrows       in integer, 
                          ncolumns    in integer, 
                          calign      in varchar2 DEFAULT NULL, 
                          cattributes in varchar2 DEFAULT NULL) return varchar2 
 is 
begin return('&lt;TEXTAREA NAME=&quot;'||cname||'&quot;'|| 
                      ' ROWS='||to_char(nrows)|| 
                      ' COLS='||to_char(ncolumns)|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
 
 
function formTextareaOpen2(cname       in varchar2, 
                          nrows       in integer, 
                          ncolumns    in integer, 
                          calign      in varchar2 DEFAULT NULL, 
                          cwrap       in varchar2 DEFAULT NULL, 
                          cattributes in varchar2 DEFAULT NULL) return varchar2 
 is 
begin return('&lt;TEXTAREA NAME=&quot;'||cname||'&quot;'|| 
                      ' ROWS='||to_char(nrows)|| 
                      ' COLS='||to_char(ncolumns)|| 
              IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
              IFNOTNULL(cwrap,' WRAP=&quot;'||cwrap||'&quot;')|| 
              IFNOTNULL(cattributes,' '||cattributes)|| 
             '&gt;'); 
end; 
/* END HTML FORMS */ 
 
/* HTML TABLES */ 
function tableOpen(cborder     in varchar2 DEFAULT NULL, 
                   calign      in varchar2 DEFAULT NULL, 
                   cnowrap     in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return ('&lt;TABLE '|| 
               IFNOTNULL(cborder,' '||cborder)|| 
               IFNOTNULL(cnowrap,' NOWRAP')|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(cclear,' CLEAR=&quot;'||cclear||'&quot;')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
              '&gt;'); end; 
 
function tableCaption(ccaption in varchar2, 
                      calign   in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return ('&lt;CAPTION'|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
              '&gt;'|| 
              ccaption||'&lt;/CAPTION&gt;'); end; 
 
function tableRowOpen(calign      in varchar2 DEFAULT NULL, 
                      cvalign     in varchar2 DEFAULT NULL, 
                      cdp         in varchar2 DEFAULT NULL, 
                      cnowrap     in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return ('&lt;TR'|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(cvalign,' VALIGN=&quot;'||cvalign||'&quot;')|| 
               IFNOTNULL(cdp,' DP=&quot;'||cdp||'&quot;')|| 
               IFNOTNULL(cnowrap,' NOWRAP')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
              '&gt;'); end; 
 
function tableHeader(cvalue      in varchar2 DEFAULT NULL, 
                     calign      in varchar2 DEFAULT NULL, 
                     cdp         in varchar2 DEFAULT NULL, 
                     cnowrap     in varchar2 DEFAULT NULL, 
                     crowspan    in varchar2 DEFAULT NULL, 
                     ccolspan    in varchar2 DEFAULT NULL, 
                     cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return ('&lt;TH'|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(cdp,' DP=&quot;'||cdp||'&quot;')|| 
               IFNOTNULL(crowspan,' ROWSPAN=&quot;'||crowspan||'&quot;')|| 
               IFNOTNULL(ccolspan,' COLSPAN=&quot;'||ccolspan||'&quot;')|| 
               IFNOTNULL(cnowrap,' NOWRAP')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
              '&gt;'|| 
              cvalue||'&lt;/TH&gt;'); end; 
  
function tableData(cvalue      in varchar2 DEFAULT NULL, 
                   calign      in varchar2 DEFAULT NULL, 
                   cdp         in varchar2 DEFAULT NULL, 
                   cnowrap     in varchar2 DEFAULT NULL, 
                   crowspan    in varchar2 DEFAULT NULL, 
                   ccolspan    in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) return varchar2 is 
begin return ('&lt;TD'|| 
               IFNOTNULL(calign,' ALIGN=&quot;'||calign||'&quot;')|| 
               IFNOTNULL(cdp,' DP=&quot;'||cdp||'&quot;')|| 
               IFNOTNULL(crowspan,' ROWSPAN=&quot;'||crowspan||'&quot;')|| 
               IFNOTNULL(ccolspan,' COLSPAN=&quot;'||ccolspan||'&quot;')|| 
               IFNOTNULL(cnowrap,' NOWRAP')|| 
               IFNOTNULL(cattributes,' '||cattributes)|| 
              '&gt;'|| 
              cvalue||'&lt;/TD&gt;'); end; 
/* END HTML TABLES */ 
 
/* BEGIN HTML FRAMES - Netscape Extensions FRAMESET, FRAME tags */ 
function framesetOpen(	crows	in varchar2 DEFAULT NULL,			/* row height value list */ 
			ccols	in varchar2 DEFAULT NULL, 
			cattributes in varchar2 DEFAULT NULL) return varchar2 is	/* column width list */ 
begin   
 return('&lt;FRAMESET'|| 
	IFNOTNULL(crows, ' ROWS=&quot;'||crows||'&quot;')|| 
	IFNOTNULL(ccols, ' COLS=&quot;'||ccols||'&quot;')|| 
	IFNOTNULL(cattributes,' '||cattributes)|| 
	'&gt;');  
end framesetOpen; 
 
 
function frame(		csrc	in varchar2,				/* URL */ 
			cname	in varchar2 DEFAULT NULL,		/* Window name */ 
			cmarginwidth 	in varchar2 DEFAULT NULL,	/* value in pixels */ 
			cmarginheight	in varchar2 DEFAULT NULL,	/* value in pixels */ 
			cscrolling	in varchar2 DEFAULT NULL,	/* yes | no | auto */ 
			cnoresize	in varchar2 DEFAULT NULL, 
			cattributes	in varchar2 DEFAULT NULL) return varchar2 is	/* user cannot resize frame */ 
begin  
 return('&lt;FRAME SRC=&quot;'||csrc||'&quot;'|| 
	IFNOTNULL(cname, ' NAME=&quot;'||cname||'&quot;')|| 
	IFNOTNULL(cmarginwidth, ' MARGINWIDTH=&quot;'||cmarginwidth||'&quot;')|| 
	IFNOTNULL(cmarginheight, ' MARGINHEIGHT=&quot;'||cmarginheight||'&quot;')|| 
	IFNOTNULL(cscrolling, ' SCROLLING=&quot;'||cscrolling||'&quot;')|| 
	IFNOTNULL(cnoresize, ' NORESIZE')|| 
	IFNOTNULL(cattributes,' '||cattributes)|| 
	'&gt;'); 
end frame; 
 
 
/* END HTML FRAMES */ 
 
 
/* SPECIAL FUNCTIONS */ 
function escape_sc(ctext in varchar2) return varchar2 is 
begin return(replace( 
             replace( 
             replace( 
             replace( 
             replace(ctext, '&amp;', '&amp;amp;' ), 
                            '%25', '%2525'   ), 
                            '&quot;', '&amp;quot;'), 
                            '&lt;', '&amp;lt;'  ), 
                            '&gt;', '&amp;gt;'  )); 
end; 
/* END SPECIAL FUNCTIONS */ 
 
/* END BODY ELEMENT tags */ 
end; 
</PRE>
<HR>
This page was produced by the 
<B>Oracle Web Agent</B> on November  12, 1997 05:00 PM<BR>
<BR>
<HR>
<A HREF="/ows-adoc/Intro.html"><IMG SRC="/ows-img/navadm.gif" ALT="Administration"></A><A HREF="/owa_dba/owa/browse.intro"><IMG SRC="/ows-img/navbrws.gif" ALT="Browse"></A><A HREF="/ows-doc/index.html"><IMG SRC="/ows-img/navhome.gif" ALT="OWS Home"></A>

--------------56483510231C--


From yuzhu@postoffice.npac.syr.edu Wed Nov 12 16:44 EST 1997
Received: from scorpio.npac.syr.edu (scorpio.npac.syr.edu [128.230.14.16]) by postoffice.npac.syr.edu (8.7.5/8.7.1) with ESMTP id QAA28117 for <msen7@postoffice.npac.syr.edu>; Wed, 12 Nov 1997 16:44:33 -0500 (EST)
Received: from osprey2.npac.syr.edu (osprey2.npac.syr.edu [128.230.164.132]) by scorpio.npac.syr.edu (8.7.5/8.7.1) with SMTP id QAA05766 for <msen7@npac.syr.edu>; Wed, 12 Nov 1997 16:38:10 -0500 (EST)
Sender: yuzhu@npac.syr.edu
Message-ID: <346A2339.451@npac.syr.edu>
Date: Wed, 12 Nov 1997 16:44:25 -0500
From: Yuping Zhu <yuzhu@npac.syr.edu>
X-Mailer: Mozilla 3.0 (X11; I; SunOS 5.5.1 sun4u)
MIME-Version: 1.0
To: msen7@postoffice.npac.syr.edu
Subject: Source code for HTP
Content-Type: multipart/mixed; boundary="------------1FAA53345CC4"
Content-Length: 40380
X-Status: 
Status: RO

This is a multi-part message in MIME format.

--------------1FAA53345CC4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

http://osprey7:8888/owa_dba/owa/browse.show_source?cname=GRID1.HTP

--------------1FAA53345CC4
Content-Type: text/html; charset=us-ascii; name="browse.show_source"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="browse.show_source"
Content-Base: "http://osprey7:8888/owa_dba/owa/browse
	.show_source?cname=GRID1.HTP"

<BASE HREF="http://osprey7:8888/owa_dba/owa/browse.show_source?cname=GRID1.HTP">

<TITLE>Source code for HTP</TITLE>
<H1>Source code for HTP</H1>
<PRE>
package htp as 
 
/* STRUCTURE tags */ 
procedure htmlOpen; 
procedure htmlClose; 
procedure headOpen; 
procedure headClose; 
procedure bodyOpen(cbackground in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL)   ; 
procedure bodyClose; 
/* END STRUCTURE tags */ 
 
/* HEAD Related elements tags */ 
procedure title  (ctitle in varchar2)                      ; 
procedure htitle(ctitle      in varchar2, 
                 nsize       in integer  DEFAULT 1, 
                 calign      in varchar2 DEFAULT NULL, 
                 cnowrap     in varchar2 DEFAULT NULL, 
                 cclear      in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL)     ; 
procedure base(	ctarget	in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL); 
procedure isindex(cprompt in varchar2 DEFAULT NULL, 
                  curl    in varchar2 DEFAULT NULL) ; 
procedure linkRel(crel   in varchar2, 
                  curl   in varchar2,  
                  ctitle in varchar2 DEFAULT NULL)          ; 
procedure linkRev(crev  in varchar2,  
                  curl  in varchar2,  
                  ctitle in varchar2 DEFAULT NULL)          ; 
procedure meta(chttp_equiv in varchar2, 
               cname       in varchar2, 
               ccontent    in varchar2)                     ; 
procedure nextid(cidentifier in varchar2)                   ; 
/* END HEAD Related elements tags */ 
 
/* BODY ELEMENT tags */ 
procedure hr  (cclear      in varchar2 DEFAULT NULL, 
               csrc        in varchar2 DEFAULT NULL, 
               cattributes in varchar2 DEFAULT NULL)       ; 
procedure line(cclear      in varchar2 DEFAULT NULL, 
               csrc        in varchar2 DEFAULT NULL, 
               cattributes in varchar2 DEFAULT NULL)       ; 
procedure br(cclear      in varchar2 DEFAULT NULL, 
             cattributes in varchar2 DEFAULT NULL)         ; 
procedure nl(cclear      in varchar2 DEFAULT NULL, 
             cattributes in varchar2 DEFAULT NULL)         ; 
 
procedure header(nsize   in integer, 
                 cheader in varchar2, 
                 calign  in varchar2 DEFAULT NULL, 
                 cnowrap in varchar2 DEFAULT NULL, 
                 cclear  in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL)     ; 
procedure anchor(curl        in varchar2, 
                 ctext       in varchar2, 
                 cname       in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL)     ; 
procedure anchor2(curl        in varchar2, 
                 ctext       in varchar2, 
                 cname       in varchar2 DEFAULT NULL, 
		 ctarget     in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL)     ; 
procedure mailto(caddress    in varchar2, 
                 ctext       in varchar2, 
                 cname       in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL)     ; 
procedure img(curl        in varchar2, 
              calign      in varchar2 DEFAULT NULL, 
              calt        in varchar2 DEFAULT NULL, 
              cismap      in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL)        ; 
procedure img2(curl        in varchar2, 
              calign      in varchar2 DEFAULT NULL, 
              calt        in varchar2 DEFAULT NULL, 
              cismap      in varchar2 DEFAULT NULL, 
              cusemap     in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL)        ; 
procedure area(	ccoords	in varchar2, 
               	cshape	in varchar2 DEFAULT NULL, 
              	chref	in varchar2 DEFAULT NULL, 
              	cnohref in varchar2 DEFAULT NULL, 
		ctarget in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL); 
 
procedure mapOpen(cname	in varchar2, 
		  cattributes in varchar2 DEFAULT NULL); 
procedure mapClose; 
 
procedure bgsound(csrc	in varchar2, 
		  cloop	in varchar2 DEFAULT NULL, 
		  cattributes in varchar2 DEFAULT NULL); 
 
 
procedure para; 
procedure paragraph(calign       in varchar2 DEFAULT NULL, 
                    cnowrap      in varchar2 DEFAULT NULL, 
                    cclear       in varchar2 DEFAULT NULL, 
                    cattributes  in varchar2 DEFAULT NULL) ; 
procedure div(	calign       in varchar2 DEFAULT NULL, 
                cattributes  in varchar2 DEFAULT NULL) ; 
procedure address(cvalue       in varchar2, 
                  cnowrap      in varchar2 DEFAULT NULL, 
                  cclear       in varchar2 DEFAULT NULL, 
                  cattributes  in varchar2 DEFAULT NULL)   ; 
procedure comment(ctext in varchar2)                       ; 
procedure preOpen(cclear      in varchar2 DEFAULT NULL, 
                  cwidth      in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL)    ; 
procedure preClose; 
procedure listingOpen; 
procedure listingClose; 
procedure nobr(ctext in varchar2); 
procedure wbr; 
procedure center(ctext in varchar2); 
procedure centerOpen; 
procedure centerClose; 
 
procedure blockquoteOpen(cnowrap      in varchar2 DEFAULT NULL, 
                         cclear       in varchar2 DEFAULT NULL, 
                         cattributes  in varchar2 DEFAULT NULL) ; 
procedure blockquoteClose; 
 
/* LIST tags */ 
procedure listHeader(ctext in varchar2, 
                     cattributes in varchar2 DEFAULT NULL) ; 
procedure listItem(ctext       in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cdingbat    in varchar2 DEFAULT NULL, 
                   csrc        in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL)   ; 
procedure ulistOpen(cclear      in varchar2 DEFAULT NULL, 
                    cwrap       in varchar2 DEFAULT NULL, 
                    cdingbat    in varchar2 DEFAULT NULL, 
                    csrc        in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL)  ; 
procedure ulistClose; 
procedure olistOpen(cclear      in varchar2 DEFAULT NULL, 
                    cwrap       in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL)  ; 
procedure olistClose; 
procedure dlistOpen(cclear      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL)  ; 
procedure dlistTerm(ctext       in varchar2 DEFAULT NULL, 
                    cclear      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL)  ; 
procedure dlistDef(ctext       in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL)  ; 
procedure dlistClose; 
 
procedure menulistOpen; 
procedure menulistClose; 
procedure dirlistOpen; 
procedure dirlistClose; 
/* END LIST tags */ 
 
/* SEMANTIC FORMAT ELEMENTS */ 
procedure dfn(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) ; 
procedure cite(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) ; 
procedure code(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) ; 
procedure em(ctext in varchar2, 
             cattributes in varchar2 DEFAULT NULL) ; 
procedure emphasis(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) ; 
procedure keyboard(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) ; 
procedure kbd(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) ; 
procedure sample(ctext in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) ; 
procedure strong(ctext in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) ; 
procedure variable(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) ; 
procedure big(	ctext 		in varchar2, 
		cattributes 	in varchar2 DEFAULT NULL); 
procedure small(ctext 		in varchar2, 
		cattributes 	in varchar2 DEFAULT NULL); 
procedure sub(	ctext 		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
		cattributes 	in varchar2 DEFAULT NULL); 
procedure sup(	ctext 		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
		cattributes 	in varchar2 DEFAULT NULL); 
 
/* END SEMANTIC FORMAT ELEMENTS */ 
 
/* PHYSICAL FORMAT ELEMENTS */ 
procedure basefont(nsize in integer); 
procedure fontOpen(	ccolor	in varchar2 DEFAULT NULL, 
		cface	in varchar2 DEFAULT NULL, 
		csize	in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL); 
procedure fontClose; 
procedure bold(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) ; 
procedure italic(ctext in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) ; 
procedure teletype(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) ; 
procedure plaintext(ctext in varchar2, 
                    cattributes in varchar2 DEFAULT NULL) ; 
procedure s(ctext in varchar2, 
            cattributes in varchar2 DEFAULT NULL) ; 
procedure strike(ctext in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) ; 
/* END PHYSICAL FORMAT ELEMENTS */ 
 
/* HTML FORMS */ 
procedure formOpen(curl     in varchar2, 
                   cmethod  in varchar2 DEFAULT 'POST', 
		   ctarget  in varchar2 DEFAULT NULL, 
		   cenctype in varchar2 DEFAULT NULL,  
		   cattributes in varchar2 DEFAULT NULL); 
 
procedure formCheckbox(cname       in varchar2, 
                       cvalue      in varchar2 DEFAULT 'on', 
                       cchecked    in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL); 
procedure formHidden(cname       in varchar2, 
                     cvalue      in varchar2 DEFAULT NULL, 
                     cattributes in varchar2 DEFAULT NULL); 
procedure formImage(cname       in varchar2, 
                    csrc        in varchar2, 
                    calign      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL); 
procedure formPassword(cname       in varchar2, 
                       csize       in varchar2 DEFAULT NULL, 
                       cmaxlength  in varchar2 DEFAULT NULL, 
                       cvalue      in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL); 
procedure formRadio(cname       in varchar2, 
                    cvalue      in varchar2, 
                    cchecked    in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL); 
procedure formReset(cvalue      in varchar2 DEFAULT 'Reset', 
                    cattributes in varchar2 DEFAULT NULL); 
procedure formSubmit(cname       in varchar2 DEFAULT NULL, 
                     cvalue      in varchar2 DEFAULT 'Submit', 
                     cattributes in varchar2 DEFAULT NULL); 
procedure formText(cname       in varchar2, 
                   csize       in varchar2 DEFAULT NULL, 
                   cmaxlength  in varchar2 DEFAULT NULL, 
                   cvalue      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL); 
 
procedure formSelectOpen(cname       in varchar2, 
                         cprompt     in varchar2 DEFAULT NULL, 
                         nsize       in integer  DEFAULT NULL, 
                         cattributes in varchar2 DEFAULT NULL); 
procedure formSelectOption(cvalue      in varchar2, 
                           cselected   in varchar2 DEFAULT NULL, 
                           cattributes in varchar2 DEFAULT NULL); 
procedure formSelectClose; 
 
procedure formTextarea(cname       in varchar2, 
                       nrows       in integer, 
                       ncolumns    in integer, 
                       calign      in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL);  
 
procedure formTextarea2(cname       in varchar2, 
                       nrows       in integer, 
                       ncolumns    in integer, 
                       calign      in varchar2 DEFAULT NULL, 
		       cwrap	   in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL);  
 
procedure formTextareaOpen(cname       in varchar2, 
                           nrows       in integer, 
                           ncolumns    in integer, 
                           calign      in varchar2 DEFAULT NULL, 
                           cattributes in varchar2 DEFAULT NULL);  
 
procedure formTextareaOpen2(cname       in varchar2, 
                           nrows       in integer, 
                           ncolumns    in integer, 
                           calign      in varchar2 DEFAULT NULL, 
			   cwrap       in varchar2 DEFAULT NULL, 
                           cattributes in varchar2 DEFAULT NULL);  
procedure formTextareaClose; 
 
procedure formClose; 
/* END HTML FORMS */ 
 
/* HTML TABLES */ 
procedure tableOpen(cborder     in varchar2 DEFAULT NULL, 
                    calign      in varchar2 DEFAULT NULL, 
                    cnowrap     in varchar2 DEFAULT NULL, 
                    cclear      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL); 
procedure tableCaption(ccaption    in varchar2, 
                       calign      in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL); 
procedure tableRowOpen(calign      in varchar2 DEFAULT NULL, 
                       cvalign     in varchar2 DEFAULT NULL, 
                       cdp         in varchar2 DEFAULT NULL, 
                       cnowrap     in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL); 
procedure tableHeader(cvalue      in varchar2 DEFAULT NULL, 
                      calign      in varchar2 DEFAULT NULL, 
                      cdp         in varchar2 DEFAULT NULL, 
                      cnowrap     in varchar2 DEFAULT NULL, 
                      crowspan    in varchar2 DEFAULT NULL, 
                      ccolspan    in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL); 
procedure tableData(cvalue      in varchar2 DEFAULT NULL, 
                    calign      in varchar2 DEFAULT NULL, 
                    cdp         in varchar2 DEFAULT NULL, 
                    cnowrap     in varchar2 DEFAULT NULL, 
                    crowspan    in varchar2 DEFAULT NULL, 
                    ccolspan    in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL); 
procedure tableRowClose; 
 
procedure tableClose; 
/* END HTML TABLES */ 
 
/* BEGIN HTML FRAMES - Netscape Extensions FRAMESET, FRAME tags */ 
procedure framesetOpen(	crows in varchar2 DEFAULT NULL,	/* row height value list */ 
			ccols in varchar2 DEFAULT NULL, 
			cattributes in varchar2 DEFAULT NULL);	/* column width list */ 
procedure framesetClose; 
procedure frame(	csrc	in varchar2,				/* URL */ 
			cname	in varchar2 DEFAULT NULL,		/* Window Name */ 
			cmarginwidth 	in varchar2 DEFAULT NULL,	/* Value in pixels */ 
			cmarginheight	in varchar2 DEFAULT NULL,	/* Value in pixels */ 
			cscrolling	in varchar2 DEFAULT NULL,	/* yes | no | auto */ 
			cnoresize	in varchar2 DEFAULT NULL, 
			cattributes 	in varchar2 DEFAULT NULL);	/* Not resizable by user */ 
procedure noframesOpen; 
procedure noframesClose; 
 
/* END FRAMES */ 
 
/* END BODY ELEMENT tags */ 
 
/* SPECIAL PROCEDURES */ 
  -- Output Procedures 
procedure print (cbuf in varchar2 DEFAULT NULL); 
procedure print (dbuf in date); 
procedure print (nbuf in number); 
 
  -- Output without the newline 
procedure prn (cbuf in varchar2 DEFAULT NULL); 
procedure prn (dbuf in date); 
procedure prn (nbuf in number); 
 
  -- Abbrev call to print() 
procedure p (cbuf in varchar2 DEFAULT NULL); 
procedure p (dbuf in date); 
procedure p (nbuf in number); 
 
procedure prints(ctext in varchar2); 
procedure ps(ctext in varchar2); 
procedure escape_sc(ctext in varchar2); 
/* END SPECIAL PROCEDURES */ 
 
/* STRUCTURES FOR htp.print */ 
-- PL/SQL table used for output buffering 
HTBUF_LEN constant integer := 255; 
type htbuf_arr is table of varchar2(256) index by binary_integer; 
 
-- The customer should not modify any of these values directly. 
htbuf htbuf_arr; 
rows_in number := 0; 
rows_out number := 0; 
/* END STRUCTURES FOR htp.print */ 
 
end; 

package body htp as 
 
/* STRUCTURE tags */ 
procedure htmlOpen is 
begin p(htf.htmlOpen); end; 
 
procedure htmlClose is 
begin p(htf.htmlClose); end; 
 
procedure headOpen is 
begin p(htf.headOpen); end; 
 
procedure headClose is 
begin p(htf.headClose); end; 
 
procedure bodyOpen(cbackground in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.bodyOpen(cbackground,cattributes)); end; 
 
procedure bodyClose is 
begin p(htf.bodyClose); end; 
/* END STRUCTURE tags */ 
 
/* HEAD Related elements tags */ 
procedure title  (ctitle in varchar2) is 
begin p(htf.title(ctitle)); end; 
 
procedure htitle(ctitle      in varchar2, 
                 nsize       in integer  DEFAULT 1, 
                 calign      in varchar2 DEFAULT NULL, 
                 cnowrap     in varchar2 DEFAULT NULL, 
                 cclear      in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.htitle(ctitle,nsize,calign,cnowrap,cclear,cattributes)); end; 
 
procedure base(	ctarget 	in varchar2 DEFAULT NULL, 
		cattributes	in varchar2 DEFAULT NULL) is 
begin p(htf.base(ctarget,cattributes)); end; 
 
procedure isindex(cprompt in varchar2 DEFAULT NULL, 
                  curl    in varchar2 DEFAULT NULL) is 
begin p(htf.isindex(cprompt, curl)); end; 
 
procedure linkRel(crel   in varchar2, 
                  curl   in varchar2,  
                  ctitle in varchar2 DEFAULT NULL) is 
begin p(htf.linkRel(crel, curl, ctitle)); end; 
 
procedure linkRev(crev   in varchar2, 
                  curl   in varchar2,  
                  ctitle in varchar2 DEFAULT NULL) is 
begin p(htf.linkRev(crev, curl, ctitle)); end; 
 
procedure meta(chttp_equiv in varchar2, 
               cname       in varchar2, 
               ccontent    in varchar2) is  
begin p(htf.meta(chttp_equiv, cname, ccontent)); end; 
 
procedure nextid(cidentifier in varchar2) is  
begin p(htf.nextid(cidentifier)); end; 
/* END HEAD Related elements tags */ 
 
/* BODY ELEMENT tags */ 
procedure hr  (cclear      in varchar2 DEFAULT NULL, 
               csrc        in varchar2 DEFAULT NULL, 
               cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.hr(cclear, csrc, cattributes)); end; 
 
procedure line(cclear      in varchar2 DEFAULT NULL, 
               csrc        in varchar2 DEFAULT NULL, 
               cattributes in varchar2 DEFAULT NULL) is  
begin htp.hr(cclear, csrc, cattributes); end; 
 
procedure nl  (cclear      in varchar2 DEFAULT NULL, 
               cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.nl(cclear,cattributes)); end; 
 
procedure br  (cclear      in varchar2 DEFAULT NULL, 
               cattributes in varchar2 DEFAULT NULL) is  
begin htp.nl(cclear,cattributes); end; 
 
procedure header(nsize   in integer, 
                 cheader in varchar2, 
                 calign  in varchar2 DEFAULT NULL, 
                 cnowrap in varchar2 DEFAULT NULL, 
                 cclear  in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.header(nsize,cheader,calign,cnowrap,cclear,cattributes)); end; 
 
procedure anchor(curl        in varchar2, 
                 ctext       in varchar2, 
                 cname       in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.anchor(curl,ctext,cname,cattributes)); end; 
 
procedure anchor2(curl        in varchar2, 
                 ctext       in varchar2, 
                 cname       in varchar2 DEFAULT NULL, 
		 ctarget     in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.anchor2(curl,ctext,cname,ctarget,cattributes)); end; 
 
procedure mailto(caddress    in varchar2, 
                 ctext       in varchar2, 
                 cname       in varchar2 DEFAULT NULL, 
                 cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.mailto(caddress,ctext,cname,cattributes)); end; 
 
procedure img(curl        in varchar2, 
              calign      in varchar2 DEFAULT NULL, 
              calt        in varchar2 DEFAULT NULL, 
              cismap      in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.img(curl,calign,calt,cismap,cattributes)); end; 
 
procedure img2(curl        in varchar2, 
              calign      in varchar2 DEFAULT NULL, 
              calt        in varchar2 DEFAULT NULL, 
              cismap      in varchar2 DEFAULT NULL, 
              cusemap     in varchar2 DEFAULT NULL, 
              cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.img2(curl,calign,calt,cismap,cusemap,cattributes)); end; 
 
procedure area(	ccoords	in varchar2, 
              	cshape	in varchar2 DEFAULT NULL, 
              	chref	in varchar2 DEFAULT NULL, 
             	cnohref	in varchar2 DEFAULT NULL, 
		ctarget in varchar2 DEFAULT NULL, 
		cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.area(ccoords,cshape,chref,cnohref,ctarget,cattributes));end; 
 
procedure mapOpen(cname	in varchar2,cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.mapOpen(cname,cattributes)); end; 
procedure mapClose is 
begin p(htf.mapClose); end; 
 
procedure bgsound(csrc	in varchar2, 
		  cloop	in varchar2 DEFAULT NULL, 
		  cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.bgsound(csrc,cloop,cattributes));end; 
 
procedure para is 
begin p(htf.para); end; 
 
procedure paragraph(calign       in varchar2 DEFAULT NULL, 
                    cnowrap      in varchar2 DEFAULT NULL, 
                    cclear       in varchar2 DEFAULT NULL, 
                    cattributes  in varchar2 DEFAULT NULL) is 
begin p(htf.paragraph(calign,cnowrap,cclear,cattributes)); end; 
 
procedure div(	calign       in varchar2 DEFAULT NULL, 
                cattributes  in varchar2 DEFAULT NULL) is 
begin p(htf.div(calign,cattributes)); end; 
 
procedure address(cvalue       in varchar2, 
                  cnowrap      in varchar2 DEFAULT NULL, 
                  cclear       in varchar2 DEFAULT NULL, 
                  cattributes  in varchar2 DEFAULT NULL) is 
begin p(htf.address(cvalue, cnowrap, cclear, cattributes)); end; 
 
procedure comment(ctext in varchar2) is 
begin p(htf.comment(ctext)); end; 
 
procedure preOpen(cclear      in varchar2 DEFAULT NULL, 
                  cwidth      in varchar2 DEFAULT NULL, 
                  cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.preOpen(cclear,cwidth,cattributes)); end; 
 
procedure preClose is 
begin p(htf.preClose); end; 
 
procedure listingOpen is 
begin p(htf.listingOpen); end; 
procedure listingClose is 
begin p(htf.listingClose); end; 
 
procedure nobr(ctext in varchar2) is 
begin p(htf.nobr(ctext)); end; 
procedure wbr is 
begin p(htf.wbr); end; 
 
procedure center(ctext in varchar2) is 
begin p(htf.center(ctext)); end; 
 
procedure centerOpen is 
begin p(htf.centerOpen); end; 
 
procedure centerClose is 
begin p(htf.centerClose); end; 
 
 
 
procedure blockquoteOpen(cnowrap      in varchar2 DEFAULT NULL, 
                         cclear       in varchar2 DEFAULT NULL, 
                         cattributes  in varchar2 DEFAULT NULL) is 
begin p(htf.blockquoteOpen(cnowrap,cclear,cattributes)); end; 
 
procedure blockquoteClose is 
begin p(htf.blockquoteClose); end; 
 
/* LIST tags */ 
procedure listHeader(ctext in varchar2, 
                     cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.listHeader(ctext,cattributes)); end; 
 
procedure listItem(ctext       in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cdingbat    in varchar2 DEFAULT NULL, 
                   csrc        in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.listItem(ctext,cclear,cdingbat,csrc,cattributes)); end; 
 
procedure ulistOpen(cclear      in varchar2 DEFAULT NULL, 
                    cwrap       in varchar2 DEFAULT NULL, 
                    cdingbat    in varchar2 DEFAULT NULL, 
                    csrc        in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.ulistOpen(cclear,cwrap,cdingbat,csrc,cattributes)); end; 
 
procedure ulistClose is 
begin p(htf.ulistClose); end; 
 
procedure olistOpen(cclear      in varchar2 DEFAULT NULL, 
                    cwrap       in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.olistOpen(cclear,cwrap,cattributes)); end; 
 
procedure olistClose is 
begin p(htf.olistClose); end; 
 
procedure dlistOpen(cclear      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.dlistOpen(cclear,cattributes)); end; 
 
procedure dlistTerm(ctext       in varchar2 DEFAULT NULL, 
                    cclear      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.dlistTerm(ctext,cclear,cattributes)); end; 
 
procedure dlistDef(ctext       in varchar2 DEFAULT NULL, 
                   cclear      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) is  
begin p(htf.dlistDef(ctext,cclear,cattributes)); end; 
 
procedure dlistClose is 
begin p(htf.dlistClose); end; 
 
procedure menulistOpen is 
begin p(htf.menulistOpen); end; 
 
procedure menulistClose is 
begin p(htf.menulistClose); end; 
 
procedure dirlistOpen is 
begin p(htf.dirlistOpen); end; 
 
procedure dirlistClose is 
begin p(htf.dirlistClose); end; 
/* END LIST tags */ 
 
/* SEMANTIC FORMAT ELEMENTS */ 
procedure dfn(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.dfn(ctext,cattributes)); end; 
 
procedure cite(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.cite(ctext,cattributes)); end; 
 
procedure code(ctext in varchar2, 
               cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.code(ctext,cattributes)); end; 
 
procedure em(ctext  in varchar2, 
             cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.em(ctext,cattributes)); end; 
 
procedure emphasis(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.emphasis(ctext,cattributes)); end; 
 
procedure kbd(ctext in varchar2, 
              cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.kbd(ctext,cattributes)); end; 
 
procedure keyboard(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.keyboard(ctext,cattributes)); end; 
 
procedure sample(ctext in varchar2, 
                 cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.sample(ctext,cattributes)); end; 
 
procedure strong (ctext  in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.strong(ctext,cattributes)); end; 
 
procedure variable(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.variable(ctext,cattributes)); end; 
 
procedure big(	ctext  		in varchar2, 
                cattributes 	in varchar2 DEFAULT NULL) is 
begin p(htf.big(ctext,cattributes)); end; 
 
procedure small(ctext  		in varchar2, 
                cattributes 	in varchar2 DEFAULT NULL) is 
begin p(htf.small(ctext,cattributes)); end; 
 
procedure sub(	ctext  		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
                cattributes 	in varchar2 DEFAULT NULL) is 
begin p(htf.sub(ctext,calign,cattributes)); end; 
 
procedure sup(	ctext  		in varchar2, 
		calign		in varchar2 DEFAULT NULL, 
                cattributes 	in varchar2 DEFAULT NULL) is 
begin p(htf.sup(ctext,calign,cattributes)); end; 
 
 
/* END SEMANTIC FORMAT ELEMENTS */ 
 
/* PHYSICAL FORMAT ELEMENTS */ 
procedure basefont(nsize in integer) is 
begin p(htf.basefont(nsize));end; 
 
procedure fontOpen(ccolor	in varchar2 DEFAULT NULL, 
		   cface	in varchar2 DEFAULT NULL, 
		   csize 	in varchar2 DEFAULT NULL, 
		   cattributes	in varchar2 DEFAULT NULL) is 
begin p(htf.fontOpen(ccolor,cface,csize,cattributes)); end; 
	 
procedure fontClose is 
begin p(htf.fontClose); end; 
 
procedure bold   (ctext  in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.bold(ctext,cattributes)); end; 
 
procedure italic (ctext  in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.italic(ctext,cattributes)); end; 
 
procedure teletype(ctext in varchar2, 
                   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.teletype(ctext,cattributes)); end; 
 
procedure plaintext(ctext  in varchar2, 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.plaintext(ctext,cattributes)); end; 
 
procedure s(ctext  in varchar2, 
            cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.s(ctext,cattributes)); end; 
 
procedure strike (ctext  in varchar2, 
                  cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.strike(ctext,cattributes)); end; 
 
/* END PHYSICAL FORMAT ELEMENTS */ 
 
/* HTML FORMS */ 
 
procedure formOpen(curl     in varchar2, 
                   cmethod  in varchar2 DEFAULT 'POST', 
		   ctarget  in varchar2 DEFAULT NULL, 
		   cenctype in varchar2 DEFAULT NULL, 
		   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formOpen(curl,cmethod,ctarget,cenctype,cattributes)); end; 
 
procedure formCheckbox(cname       in varchar2, 
                       cvalue      in varchar2 DEFAULT 'on', 
                       cchecked    in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formCheckbox(cname,cvalue,cchecked,cattributes)); end; 
 
procedure formHidden(cname       in varchar2, 
                     cvalue      in varchar2 DEFAULT NULL, 
                     cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formHidden(cname,cvalue,cattributes)); end; 
 
procedure formImage(cname       in varchar2, 
                    csrc        in varchar2, 
                    calign      in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formImage(cname,csrc,calign,cattributes)); end; 
 
procedure formPassword(cname       in varchar2, 
                       csize       in varchar2 DEFAULT NULL, 
                       cmaxlength  in varchar2 DEFAULT NULL, 
                       cvalue      in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formPassword(cname,csize,cmaxlength,cvalue,cattributes)); end; 
 
procedure formRadio(cname       in varchar2, 
                    cvalue      in varchar2, 
                    cchecked    in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formRadio(cname,cvalue,cchecked,cattributes)); end; 
 
procedure formReset(cvalue      in varchar2 DEFAULT 'Reset', 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formReset(cvalue,cattributes)); end; 
 
procedure formSubmit(cname       in varchar2 DEFAULT NULL, 
                     cvalue      in varchar2 DEFAULT 'Submit', 
                     cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formSubmit(cname,cvalue,cattributes)); end; 
 
procedure formText(cname       in varchar2, 
                   csize       in varchar2 DEFAULT NULL, 
                   cmaxlength  in varchar2 DEFAULT NULL, 
                   cvalue      in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formText(cname,csize,cmaxlength,cvalue,cattributes)); end; 
 
procedure formSelectOpen(cname       in varchar2, 
                         cprompt     in varchar2 DEFAULT NULL, 
                         nsize       in integer  DEFAULT NULL, 
                         cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formSelectOpen(cname,cprompt,nsize,cattributes)); end; 
 
procedure formSelectOption(cvalue      in varchar2, 
                           cselected   in varchar2 DEFAULT NULL, 
                           cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formSelectOption(cvalue,cselected,cattributes)); end; 
 
procedure formSelectClose is 
begin p(htf.formSelectClose); end; 
 
procedure formTextarea(cname       in varchar2, 
                       nrows       in integer, 
                       ncolumns    in integer, 
                       calign      in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formTextarea(cname,nrows,ncolumns,calign,cattributes)); end; 
  
 
procedure formTextarea2(cname       in varchar2, 
                       nrows       in integer, 
                       ncolumns    in integer, 
                       calign      in varchar2 DEFAULT NULL, 
                       cwrap       in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formTextarea2(cname,nrows,ncolumns,calign,cwrap,cattributes)); end; 
  
 
procedure formTextareaOpen(cname       in varchar2, 
                           nrows       in integer, 
                           ncolumns    in integer, 
                           calign      in varchar2 DEFAULT NULL, 
                           cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formTextareaOpen(cname,nrows,ncolumns,calign,cattributes)); end; 
  
 
procedure formTextareaOpen2(cname       in varchar2, 
                           nrows       in integer, 
                           ncolumns    in integer, 
                           calign      in varchar2 DEFAULT NULL, 
                           cwrap       in varchar2 DEFAULT NULL, 
                           cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.formTextareaOpen2(cname,nrows,ncolumns,calign,cwrap,cattributes)); end; 
  
procedure formTextareaClose is 
begin p(htf.formTextareaClose); end; 
 
procedure formClose is 
begin p(htf.formClose); end; 
/* END HTML FORMS */ 
 
/* HTML TABLES */ 
procedure tableOpen(cborder in varchar2 DEFAULT NULL, 
                   calign in varchar2 DEFAULT NULL, 
                   cnowrap in varchar2 DEFAULT NULL, 
                   cclear in varchar2 DEFAULT NULL, 
                   cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.tableOpen(cborder,calign,cnowrap,cclear,cattributes)); end; 
 
procedure tableCaption(ccaption    in varchar2, 
                       calign      in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.tableCaption(ccaption,calign,cattributes)); end; 
 
procedure tableRowOpen(calign      in varchar2 DEFAULT NULL, 
                       cvalign     in varchar2 DEFAULT NULL, 
                       cdp         in varchar2 DEFAULT NULL, 
                       cnowrap     in varchar2 DEFAULT NULL, 
                       cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.tableRowOpen(calign,cvalign,cdp,cnowrap,cattributes)); end; 
 
procedure tableHeader(cvalue      in varchar2 DEFAULT NULL, 
                      calign      in varchar2 DEFAULT NULL, 
                      cdp         in varchar2 DEFAULT NULL, 
                      cnowrap     in varchar2 DEFAULT NULL, 
                      crowspan    in varchar2 DEFAULT NULL, 
                      ccolspan    in varchar2 DEFAULT NULL, 
                      cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.tableHeader(cvalue,calign,cdp,cnowrap, 
                        crowspan,ccolspan,cattributes)); end; 
 
procedure tableData(cvalue      in varchar2 DEFAULT NULL, 
                    calign      in varchar2 DEFAULT NULL, 
                    cdp         in varchar2 DEFAULT NULL, 
                    cnowrap     in varchar2 DEFAULT NULL, 
                    crowspan    in varchar2 DEFAULT NULL, 
                    ccolspan    in varchar2 DEFAULT NULL, 
                    cattributes in varchar2 DEFAULT NULL) is 
begin p(htf.tableData(cvalue,calign,cdp,cnowrap, 
                      crowspan,ccolspan,cattributes)); end; 
 
procedure tableRowClose is 
begin p(htf.tableRowClose); end; 
 
procedure tableClose is 
begin p(htf.tableClose); end; 
/* END HTML TABLES */ 
 
/* BEGIN HTML FRAMES - Netscape Extensions FRAMESET, FRAME tags */ 
procedure framesetOpen(	crows	in varchar2 DEFAULT NULL,	/* row height value list */ 
			ccols	in varchar2 DEFAULT NULL, 
			cattributes in varchar2 DEFAULT NULL) is	/* column width list */ 
begin  
 p(htf.framesetOpen( crows, ccols, cattributes ));  
end framesetOpen; 
 
procedure framesetClose is 
begin  
 p(htf.framesetClose);  
end framesetClose; 
 
procedure frame(	csrc	in varchar2,				/* URL */ 
			cname	in varchar2 DEFAULT NULL,		/* Window Name */ 
			cmarginwidth 	in varchar2 DEFAULT NULL,	/* Value in pixels */ 
			cmarginheight	in varchar2 DEFAULT NULL,	/* Value in pixels */ 
			cscrolling	in varchar2 DEFAULT NULL,	/* yes | no | auto */ 
			cnoresize	in varchar2 DEFAULT NULL, 
			cattributes 	in varchar2 DEFAULT NULL) is	/* Not resizable by user */ 
begin  
 p(htf.frame( csrc, cname, cmarginwidth, cmarginheight, cscrolling, cnoresize, cattributes ));  
end frame; 
 
procedure noframesOpen is 
begin  
 p(htf.noframesOpen);  
end noframesOpen; 
 
procedure noframesClose is 
begin  
 p(htf.noframesClose);  
end noframesClose; 
 
/* END HTML FRAMES */ 
 
 
 
 
/* SPECIAL PROCEDURES */ 
procedure print (cbuf in varchar2 DEFAULT NULL) is 
   loc integer:=0; 
   len integer:=lengthb(cbuf); 
begin 
   while ((len - loc) &gt;= HTBUF_LEN ) 
   loop 
      rows_in := rows_in + 1; 
      htbuf(rows_in) := substrb(cbuf, loc+1, HTBUF_LEN); 
      loc := loc + HTBUF_LEN; 
   end loop; 
 
   rows_in := rows_in + 1; 
   htbuf(rows_in) := substrb(cbuf,loc+1)||' 
';  
   /* The above broken line is intentional.  Do not modify */ 
end; 
 
/* Print, but without the newline */ 
procedure prn (cbuf in varchar2 DEFAULT NULL) is 
   loc integer:=0; 
   len integer:=lengthb(cbuf); 
begin 
   while ((len - loc) &gt;= HTBUF_LEN ) 
   loop 
      rows_in := rows_in + 1; 
      htbuf(rows_in) := substrb(cbuf, loc+1, HTBUF_LEN); 
      loc := loc + HTBUF_LEN; 
   end loop; 
 
   rows_in := rows_in + 1; 
   htbuf(rows_in) := substrb(cbuf,loc+1); 
end; 
 
procedure print (dbuf in date) is 
begin print(to_char(dbuf)); end; 
 
procedure print (nbuf in number) is 
begin print(to_char(nbuf)); end; 
 
procedure prn (dbuf in date) is 
begin prn(to_char(dbuf)); end; 
 
procedure prn (nbuf in number) is 
begin prn(to_char(nbuf)); end; 
 
procedure p (cbuf in varchar2 DEFAULT NULL) is 
begin print(cbuf); end; 
 
procedure p (dbuf in date) is 
begin print(to_char(dbuf)); end; 
 
procedure p (nbuf in number) is 
begin print(to_char(nbuf)); end; 
 
procedure prints(ctext in varchar2) is 
begin p(htf.escape_sc(ctext)); end; 
 
procedure ps(ctext in varchar2) is 
begin p(htf.escape_sc(ctext)); end; 
 
procedure escape_sc(ctext in varchar2) is 
begin p(htf.escape_sc(ctext)); end; 
/* END SPECIAL PROCEDURES */ 
 
end; 
</PRE>
<HR>
This page was produced by the 
<B>Oracle Web Agent</B> on November  12, 1997 04:43 PM<BR>
<BR>
<HR>
<A HREF="/ows-adoc/Intro.html"><IMG SRC="/ows-img/navadm.gif" ALT="Administration"></A><A HREF="/owa_dba/owa/browse.intro"><IMG SRC="/ows-img/navbrws.gif" ALT="Browse"></A><A HREF="/ows-doc/index.html"><IMG SRC="/ows-img/navhome.gif" ALT="OWS Home"></A>

--------------1FAA53345CC4--


From yuzhu@postoffice.npac.syr.edu Wed Nov 12 16:35 EST 1997
Received: from scorpio.npac.syr.edu (scorpio.npac.syr.edu [128.230.14.16]) by postoffice.npac.syr.edu (8.7.5/8.7.1) with SMTP id QAA27931 for <msen7@postoffice.npac.syr.edu>; Wed, 12 Nov 1997 16:35:16 -0500 (EST)
Date: Wed, 12 Nov 1997 16:28:54 -0500 (EST)
From: Yuping Zhu <yuzhu@npac.syr.edu>
X-Sender: yuzhu@scorpio.npac.syr.edu
To: Mehmet Sen <msen7@postoffice.npac.syr.edu>
Message-ID: <Pine.GSO.3.95.971112162835.5392x-100000@scorpio.npac.syr.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Content-Length: 67
X-Status: 
Status: RO

http://osprey7:8888/owa_dba/owa/browse.show_source?cname=MSEN.HTP


From yuzhu@postoffice.npac.syr.edu Wed Dec 17 17:02 EST 1997
Received: from scorpio.npac.syr.edu (scorpio.npac.syr.edu [128.230.14.16]) by postoffice.npac.syr.edu (8.7.5/8.7.1) with ESMTP id RAA00443 for <msen7@npac.syr.edu>; Wed, 17 Dec 1997 17:02:00 -0500 (EST)
Received: from osprey2.npac.syr.edu (osprey2.npac.syr.edu [128.230.164.132]) by scorpio.npac.syr.edu (8.7.5/8.7.1) with SMTP id QAA08034 for <msen7>; Wed, 17 Dec 1997 16:55:00 -0500 (EST)
Sender: yuzhu@npac.syr.edu
Message-ID: <34984BCE.15A3@npac.syr.edu>
Date: Wed, 17 Dec 1997 17:01:50 -0500
From: Yuping Zhu <yuzhu@npac.syr.edu>
X-Mailer: Mozilla 3.0 (X11; I; SunOS 5.5.1 sun4u)
MIME-Version: 1.0
To: msen7@scorpio.npac.syr.edu
Subject: Oracle Web Listener Advanced Configuration
Content-Type: multipart/mixed; boundary="------------79A53C1B5E52"
Content-Length: 17745
Status: O

This is a multi-part message in MIME format.

--------------79A53C1B5E52
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

http://osprey7:8888/ows-abin/wladmin?FORM_CODE=GO_SEC&orig_name=other&ServerRoot=/oracle/app/oracle/product/7.3.2/ows21/admin/#SSL

--------------79A53C1B5E52
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Base: "http://osprey7:8888/ows-abin/wladmin?F
	ORM_CODE=GO_SEC&orig_name=other&Ser
	verRoot=/oracle/app/oracle/product/
	7.3.2/ows21/admin/"

<BASE HREF="http://osprey7:8888/ows-abin/wladmin?FORM_CODE=GO_SEC&orig_name=other&ServerRoot=/oracle/app/oracle/product/7.3.2/ows21/admin/#SSL">

<HTML>
<HEAD>
<TITLE> Oracle Web Listener Advanced Configuration </TITLE>
<!-- Changed by: Shehzaad Nakhoda, 21-Feb-1996 -->
<!-- Changed by: Magnus M. Lonnroth, 18-Mar-1996 -->
<!-- Changed by: Shehzaad Nakhoda, 27-Mar-1996 -->
</HEAD>

<BODY background="/ows-img/orhmbkgn.jpg" text="#000088" link="#BB0000" vlink="#BB0000">
<A HREF="/ows-abin/wladmin">
<IMG SRC="/ows-img/icnwblist.gif" width=64 height=64 border=0 align=right></A>
<IMG SRC="/ows-img/wlmdsrvr.gif" width=560 height=55 ALT="Oracle Web Listener Advanced Configuration">

<BR clear=right>

<FORM ACTION="/ows-abin/wladmin" METHOD="POST">
<INPUT TYPE="hidden" name="FORM_CODE" value="MOD_SEC">
<INPUT TYPE="hidden" name="ListenerName" value="other">
<INPUT TYPE="hidden" name="ServerRoot" value="/oracle/app/oracle/product/7.3.2/ows21/admin/">


<H2>
<font color="#BB0000">
<EM>Oracle Web Listener Security for Listener
other</EM>
</font>
</H2>

On this form are listed all of the parameters with which you can secure
your <EM>Oracle Web Listener</EM>.

<P>

Once you have made your changes, select the <EM>Modify Listener</EM> button
which can be found in several convenient locations throughout the page.

<P>

Go back to the <A HREF="/ows-abin/wladmin?FORM_CODE=INTRO&ListenerName=other&ServerRoot=/oracle/app/oracle/product/7.3.2/ows21/admin/">
Oracle Web Listener Advanced Configuration Form</A>.

<HR>

There are <STRONG>four</STRONG> different forms of security which the
<EM>Oracle Web Listener</EM> provides.  They are:<P>

<UL>
<LI> <A HREF="#Basic">Basic Authentication</A>
<LI> <A HREF="#Digest">Digest Authentication</A>
<LI> <A HREF="#IP">IP-based Restriction</A>
<LI> <A HREF="#Domain">Domain-based Restriction</A>
</UL>

After providing information on the privileged users by selecting
one of the security methods above, you must specify which files are
protected by which method by selecting the

<UL>
<LI> <A HREF="#Protection">Protection Section</A>
</UL>

<P>

Besides these access restriction-based forms of security, the
<EM>Oracle Web Listener</EM> can also secure the
communication channel by using the encryption provided by the

<UL>
<LI> <A HREF="#SSL">Secure Sockets Layer</A>
</UL>

Select this <A HREF="/ows-adoc/security.htm">Help</A> link for
help on security for the <EM>Oracle Web Listener</EM>

<HR>

<A NAME="Security">
<H2>
<font color="#BB0000">
<A HREF="/ows-adoc/security.htm#Configuring_Web_Listener_Security"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>
<EM>Security</EM>
</font>
</H2>
</A>

<A HREF="/ows-adoc/security.htm#Authentication_Parameters"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>
In the Basic and Digest sections below, you can:

<UL>
<LI>specify <STRONG>users</STRONG> and passwords
<LI>create <STRONG>groups</STRONG> of one or more users
<LI>create <STRONG>realms</STRONG> of one or more groups
</UL>

Once the form has been submitted, the users' password fields will be
blanked out for security.  If this form is resubmitted, those users
and their passwords will remain intact.

<P>

For each group, specify a space-delimited list of users.

<P>

For each realm, specify a space-delimited list of groups.

<A NAME="Basic">
<H3>
<font color="#BB0000">
<A HREF="/ows-adoc/security.htm#Basic_Users"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>
Basic Users
</font>
</H3>
</A>

<PRE>
User Name               Password
<INPUT TYPE="text" size="20" NAME="Basic(Users).1.1"> <INPUT TYPE="password" size="20" NAME="Basic(Users).1.2">
<INPUT TYPE="text" size="20" NAME="Basic(Users).2.1"> <INPUT TYPE="password" size="20" NAME="Basic(Users).2.2">
<INPUT TYPE="text" size="20" NAME="Basic(Users).3.1"> <INPUT TYPE="password" size="20" NAME="Basic(Users).3.2">
<INPUT TYPE="text" size="20" NAME="Basic(Users).4.1"> <INPUT TYPE="password" size="20" NAME="Basic(Users).4.2">
<INPUT TYPE="text" size="20" NAME="Basic(Users).5.1"> <INPUT TYPE="password" size="20" NAME="Basic(Users).5.2">

<H3><font color="#BB0000"><A HREF="/ows-adoc/security.htm#Basic_Groups"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>Basic Groups</font></H3>
Group Name              User(s)
<INPUT TYPE="text" size="20" NAME="Basic(Groups).1.1"> <INPUT TYPE="text" size="40" NAME="Basic(Groups).1.2">
<INPUT TYPE="text" size="20" NAME="Basic(Groups).2.1"> <INPUT TYPE="text" size="40" NAME="Basic(Groups).2.2">
<INPUT TYPE="text" size="20" NAME="Basic(Groups).3.1"> <INPUT TYPE="text" size="40" NAME="Basic(Groups).3.2">
<INPUT TYPE="text" size="20" NAME="Basic(Groups).4.1"> <INPUT TYPE="text" size="40" NAME="Basic(Groups).4.2">
<INPUT TYPE="text" size="20" NAME="Basic(Groups).5.1"> <INPUT TYPE="text" size="40" NAME="Basic(Groups).5.2">

<H3><font color="#BB0000"><A HREF="/ows-adoc/security.htm#Basic_Realms"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>Basic Realms</font></H3>
Realms                  Group(s)
<INPUT TYPE="text" size="20" NAME="Basic(Realms).1.1"> <INPUT TYPE="text" size="40" NAME="Basic(Realms).1.2">
<INPUT TYPE="text" size="20" NAME="Basic(Realms).2.1"> <INPUT TYPE="text" size="40" NAME="Basic(Realms).2.2">
<INPUT TYPE="text" size="20" NAME="Basic(Realms).3.1"> <INPUT TYPE="text" size="40" NAME="Basic(Realms).3.2">
<INPUT TYPE="text" size="20" NAME="Basic(Realms).4.1"> <INPUT TYPE="text" size="40" NAME="Basic(Realms).4.2">
<INPUT TYPE="text" size="20" NAME="Basic(Realms).5.1"> <INPUT TYPE="text" size="40" NAME="Basic(Realms).5.2">
</PRE>

<HR>
<INPUT TYPE="submit" NAME="SUBMIT_BUTTON" VALUE="Modify Listener">
<HR>
<A NAME="Digest"></A>
<H3><font color="#BB0000"><A HREF="/ows-adoc/security.htm#Digest_Users_Digest_Groups_and_Digest_Realms"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>Digest Users</font></H3>
<PRE>
User Name               Password
<INPUT TYPE="text" size="20" NAME="Digest(Users).1.1"> <INPUT TYPE="password" size="20" NAME="Digest(Users).1.2">
<INPUT TYPE="text" size="20" NAME="Digest(Users).2.1"> <INPUT TYPE="password" size="20" NAME="Digest(Users).2.2">
<INPUT TYPE="text" size="20" NAME="Digest(Users).3.1"> <INPUT TYPE="password" size="20" NAME="Digest(Users).3.2">
<INPUT TYPE="text" size="20" NAME="Digest(Users).4.1"> <INPUT TYPE="password" size="20" NAME="Digest(Users).4.2">
<INPUT TYPE="text" size="20" NAME="Digest(Users).5.1"> <INPUT TYPE="password" size="20" NAME="Digest(Users).5.2">

<H3><font color="#BB0000">Digest Groups</font></H3>
Group Name              User(s)
<INPUT TYPE="text" size="20" NAME="Digest(Groups).1.1"> <INPUT TYPE="text" size="40" NAME="Digest(Groups).1.2">
<INPUT TYPE="text" size="20" NAME="Digest(Groups).2.1"> <INPUT TYPE="text" size="40" NAME="Digest(Groups).2.2">
<INPUT TYPE="text" size="20" NAME="Digest(Groups).3.1"> <INPUT TYPE="text" size="40" NAME="Digest(Groups).3.2">
<INPUT TYPE="text" size="20" NAME="Digest(Groups).4.1"> <INPUT TYPE="text" size="40" NAME="Digest(Groups).4.2">
<INPUT TYPE="text" size="20" NAME="Digest(Groups).5.1"> <INPUT TYPE="text" size="40" NAME="Digest(Groups).5.2">

<H3><font color="#BB0000">Digest Realms</font></H3>
Realm                   Group(s)
<INPUT TYPE="text" size="20" NAME="Digest(Realms).1.1"> <INPUT TYPE="text" size="40" NAME="Digest(Realms).1.2">
<INPUT TYPE="text" size="20" NAME="Digest(Realms).2.1"> <INPUT TYPE="text" size="40" NAME="Digest(Realms).2.2">
<INPUT TYPE="text" size="20" NAME="Digest(Realms).3.1"> <INPUT TYPE="text" size="40" NAME="Digest(Realms).3.2">
<INPUT TYPE="text" size="20" NAME="Digest(Realms).4.1"> <INPUT TYPE="text" size="40" NAME="Digest(Realms).4.2">
<INPUT TYPE="text" size="20" NAME="Digest(Realms).5.1"> <INPUT TYPE="text" size="40" NAME="Digest(Realms).5.2">
</PRE>

<HR>
<INPUT TYPE="submit" NAME="SUBMIT_BUTTON" VALUE="Modify Listener">
<HR>

<A NAME="IP">
<H3>
<font color="#BB0000">
<A HREF="/ows-adoc/security.htm#IP-based_Restriction1"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>
IP-based restriction
</font>
</H3>
</A>

In the IP section, you can specify the IP Group name, and the corresponding 
IP address(es).
 
<P>

The list of IP addresses should be a space-delimited list, looking something
like:

<PRE>
    +144.25.19.* +144.25.18.*
</PRE>

<P>

A '+' before an IP address denotes that that particular IP address should 
be given access.

<BR>

A '-' before an IP address denotes that that particular IP address should 
be denied access.

<P>

<PRE>
IP Group               	IP Address(es)
<INPUT TYPE="text" size="20" NAME="IP.1.1"> <INPUT TYPE="text" size="40" NAME="IP.1.2">
<INPUT TYPE="text" size="20" NAME="IP.2.1"> <INPUT TYPE="text" size="40" NAME="IP.2.2">
<INPUT TYPE="text" size="20" NAME="IP.3.1"> <INPUT TYPE="text" size="40" NAME="IP.3.2">
<INPUT TYPE="text" size="20" NAME="IP.4.1"> <INPUT TYPE="text" size="40" NAME="IP.4.2">
<INPUT TYPE="text" size="20" NAME="IP.5.1"> <INPUT TYPE="text" size="40" NAME="IP.5.2">
</PRE>

<HR>
<INPUT TYPE="submit" NAME="SUBMIT_BUTTON" VALUE="Modify Listener">
<HR>

<A NAME="Domain">
<H3>
<font color="#BB0000">
<A HREF="/ows-adoc/security.htm#Domain-based_Restriction1"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>Domain-based restriction
</font>
</H3>
</A>

In the Domain section, you can specify the Domain Group name, and the 
corresponding internet domain name(s).

<P>

The list of internet domain names should be a space-delimited list, 
looking something like:

<PRE>
    +*us.mycomp.com +*sp.mycomp.com
</PRE>

<P>

A '+' before a Domain name denotes that that particular internet domain 
should be given access.

<BR>

A '-' before a Domain name denotes that that particular internet domain should be denied access.
<P>

<PRE>
Domain Group            Domain Name(s)
<INPUT TYPE="text" size="20" NAME="Domain.1.1"> <INPUT TYPE="text" size="40" NAME="Domain.1.2">
<INPUT TYPE="text" size="20" NAME="Domain.2.1"> <INPUT TYPE="text" size="40" NAME="Domain.2.2">
<INPUT TYPE="text" size="20" NAME="Domain.3.1"> <INPUT TYPE="text" size="40" NAME="Domain.3.2">
<INPUT TYPE="text" size="20" NAME="Domain.4.1"> <INPUT TYPE="text" size="40" NAME="Domain.4.2">
<INPUT TYPE="text" size="20" NAME="Domain.5.1"> <INPUT TYPE="text" size="40" NAME="Domain.5.2">
</PRE>

<HR>
<INPUT TYPE="submit" NAME="SUBMIT_BUTTON" VALUE="Modify Listener">
<HR>

<A NAME="Protection">
<H2>
<font color="#BB0000">
<A HREF="/ows-adoc/security.htm#Specifying_Protection_for_Files_and_Directories"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A><EM>Protection</EM>
</font>
</H2>
</A>

After providing information on the privileged users by filling in
one of the security methods above, you must specify which files are
protected by which method by selecting.

<P>

In the Protection section, you can:

<UL>
<LI>specify the file or files to protect
<LI>specify the method of user authentication (optional)
<LI>specify the method of host-based restriction (optional)
</UL>

If both user authentication <STRONG>and</STRONG> host-based restriction
are required for a particular virtual path, then specify &amp; in the drop-down
list below.

<P>

If user authentication <STRONG>or</STRONG> host-based restriction
are required for a particular virtual path, then specify | in the drop-down
list below.

<P>

<PRE>
Virtual Path           Basic/Digest    Realm                    &amp;/|      IP/Domain       Group
<INPUT TYPE="text" size="20" NAME="[Protection].1.1"> <SELECT NAME="[Protection].1.2"><OPTION> <OPTION>Basic<OPTION>Digest</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].1.3"> <SELECT NAME="[Protection].1.4"><OPTION> <OPTION>&<OPTION>|</SELECT> <SELECT NAME="[Protection].1.5"><OPTION> <OPTION>IP<OPTION>Domain</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].1.6">
<INPUT TYPE="text" size="20" NAME="[Protection].2.1"> <SELECT NAME="[Protection].2.2"><OPTION> <OPTION>Basic<OPTION>Digest</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].2.3"> <SELECT NAME="[Protection].2.4"><OPTION> <OPTION>&<OPTION>|</SELECT> <SELECT NAME="[Protection].2.5"><OPTION> <OPTION>IP<OPTION>Domain</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].2.6">
<INPUT TYPE="text" size="20" NAME="[Protection].3.1"> <SELECT NAME="[Protection].3.2"><OPTION> <OPTION>Basic<OPTION>Digest</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].3.3"> <SELECT NAME="[Protection].3.4"><OPTION> <OPTION>&<OPTION>|</SELECT> <SELECT NAME="[Protection].3.5"><OPTION> <OPTION>IP<OPTION>Domain</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].3.6">
<INPUT TYPE="text" size="20" NAME="[Protection].4.1"> <SELECT NAME="[Protection].4.2"><OPTION> <OPTION>Basic<OPTION>Digest</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].4.3"> <SELECT NAME="[Protection].4.4"><OPTION> <OPTION>&<OPTION>|</SELECT> <SELECT NAME="[Protection].4.5"><OPTION> <OPTION>IP<OPTION>Domain</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].4.6">
<INPUT TYPE="text" size="20" NAME="[Protection].5.1"> <SELECT NAME="[Protection].5.2"><OPTION> <OPTION>Basic<OPTION>Digest</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].5.3"> <SELECT NAME="[Protection].5.4"><OPTION> <OPTION>&<OPTION>|</SELECT> <SELECT NAME="[Protection].5.5"><OPTION> <OPTION>IP<OPTION>Domain</SELECT> <INPUT TYPE="text" size="20" NAME="[Protection].5.6">
</PRE>

<HR>
<INPUT TYPE="submit" NAME="SUBMIT_BUTTON" VALUE="Modify Listener">
<HR>

<H2>
<A NAME="SSL">
<font color="#BB0000">
<A HREF="/ows-adoc/security.htm#Securing_TCPIP_Ports_Using_SSL"><IMG SRC="/ows-img/iconhelp.gif" border=0 ALIGN=RIGHT></A>
<EM>Secure Sockets Layer</EM>
</font>
</A>
</H2> 
If you are adding
support for SSL, you must also configure at least one port for SSL in
the Addresses and Ports section of the Advanced Configuration
Form. All five parameters below are <STRONG>required</STRONG> for
enabling SSL.

<HR>

<H3>
<font color="#BB0000">
Certificate File
</font>
</H3>

This parameter designates the path to the file containing the
certification file you receive from your Certifying Authority.

<P>

This file must be:

<UL>
<LI> in ASCII-64 encoded DER format and have a <STRONG>.der</STRONG> 
extension, <STRONG>or</STRONG>.

<LI> in PEM certificate approval message format and have a 
<STRONG>.pem</STRONG> extension, <STRONG>or</STRONG>

<LI> in PKCS certificate approval message format and have a 
<STRONG>.pkc</STRONG> extension.
</UL>

<P>
<INPUT TYPE="hidden"  NAME="SSL.1.1" VALUE="CertFile">
Please enter the <STRONG>Certification File</STRONG>: 
<INPUT TYPE="text" size="40" NAME="SSL.1.2" VALUE="">

<HR>

<H3>
<font color="#BB0000">
Distinguished Name File
</font>
</H3>

This parameter designates the path to the file containing the
Distinguished Name information, and is created by the
<STRONG>genreq</STRONG> program. This file must be:

<UL>
<LI> <STRONG>either</STRONG> in DER format and have a 
<STRONG>.der</STRONG> extension, 

<LI> <STRONG>or</STRONG> in PEM format and have a <STRONG>.prm</STRONG> 
extension.
</UL>

<INPUT TYPE="hidden" NAME="SSL.2.1" VALUE="DistNameFile">
Please enter the <STRONG>Distinguished Name File</STRONG>: 
<INPUT TYPE="text" size="40" NAME="SSL.2.2" VALUE="">

<HR>

<H3>
<font color="#BB0000">
Key File
</font>
</H3>

This parameter designates the path to the file containing the Private Key, 
which contains an excrypted version of your RSA private key, and is created 
by the <STRONG>genreq</STRONG> program.  This file must be:

<UL>
<LI> <STRONG>either</STRONG> in DER format and have a 
<STRONG>.der</STRONG> extension, 

<LI> <STRONG>or</STRONG> in PEM format and have a 
<STRONG>.prm</STRONG> extension.
</UL>

<INPUT TYPE="hidden" NAME="SSL.3.1" VALUE="KeyFile">
Please enter the <STRONG>Key File</STRONG>: 
<INPUT TYPE="text" size="40" NAME="SSL.3.2" VALUE="">

<HR>

<H3>
<font color="#BB0000">
Certifying Authority Directory
</font>
</H3>

This parameter designates the path to the directory where additional 
Certifying Authority (CA) certificate files can be added in the future.

<P>

<INPUT TYPE="hidden" NAME="SSL.4.1" VALUE="CADir">
Please enter the <STRONG>CA Directory</STRONG>: 
<INPUT TYPE="text" size="40" NAME="SSL.4.2" VALUE="">

<HR>

<H3>
<font color="#BB0000">
Certificate Revocation List Directory
</font>
</H3>

This parameter designates the path to the directory where additional Certificate Revocation List (CRL) files can be added in the future.

<P>

<INPUT TYPE="hidden" NAME="SSL.5.1" VALUE="CRLDir">
Please enter the <STRONG>CRL Directory</STRONG>: 
<INPUT TYPE="text" size="40" NAME="SSL.5.2" VALUE="">

<HR>
<INPUT TYPE="submit" NAME="SUBMIT_BUTTON" VALUE="Modify Listener">
<HR>

</FORM>
<center>
<A HREF="/ows-adoc/Intro.html">
<IMG SRC="/ows-img/navadm.gif" ALT="Administration" border=0></A>
<A HREF="/owa_dba/owa/browse.intro">
<IMG SRC="/ows-img/navbrws.gif" ALT="Browse Database" border=0></A>
<A HREF="/ows-doc/index.html">
<IMG SRC="/ows-img/navhome.gif" ALT="OWS Home" border=0></A>
<A HREF="/ows-abin/wladmin">
<IMG SRC="/ows-img/wlhome.gif" ALT="Listener Home" border=0></A>
<A HREF="/ows-adoc/security.htm">
<IMG SRC="/ows-img/navhelp.gif" ALT="Help" border=0></A>
<p>
<IMG SRC="/ows-img/tag3.gif" width=240 height=38>
</center>
</BODY>
</HTML>

--------------79A53C1B5E52--