Rem Copyright (c) 1994 by Oracle Corp. All Rights Reserved. Rem Rem NAME Rem ht.sql - Hyper Text packages Rem PURPOSE Rem Provide utility functions for producing HTML documents Rem from pl/sql. Rem NOTES Rem Two sets of packages - one is all functions/constants (htf) Rem - one is all procedures (htp) Rem Rem A PL/SQL table of varchar2 is used to buffer output. Rem htp.print() buffers the output. Rem owa.get_page() fetches it out. Rem Rem This script should be run by the intended owner of the OWA packages. Rem HISTORY Rem mbookman 07/26/95 - Added mailto support Rem mbookman 05/23/95 - Full HTML 2.0 support Rem Numerous function/procedure name Rem changes for standardization Rem mloennro 09/05/94 - Creation Rem REM Creating HTFF package... create or replace package htff as /* STRUCTURE tags */ /*function*/ htmlOpen constant varchar2(7) := ''; /* No attributes in HTML 3.0 spec as of 6/7/95 */ /*function*/ htmlClose constant varchar2(7) := ''; /* No attributes in HTML 3.0 spec as of 6/7/95 */ /*function*/ headOpen constant varchar2(7) := ''; /* No attributes in HTML 3.0 spec as of 6/7/95 */ /*function*/ headClose constant varchar2(7) := ''; /* No attributes in HTML 3.0 spec as of 6/7/95 */ --------------------------------------------------------------- /* Begin of Jiangang Guo's Functions */ /*function*/ javascriptOpen constant varchar2(50) := ''; /* End of Jiangang Guo's Functions */ --------------------------------------------------------------- function bodyOpen (cbackground in varchar2 DEFAULT NULL, cattributes in varchar2 DEFAULT NULL) return varchar2; /*function*/ bodyClose constant varchar2(7) := ''; /* 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 return varchar2; /* No attributes in HTML 3.0 spec as of 6/7/95 */ 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 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*/ para constant varchar2(3) := '

'; 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 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) := ''; function blockquoteOpen(cnowrap in varchar2 DEFAULT NULL, cclear in varchar2 DEFAULT NULL, cattributes in varchar2 DEFAULT NULL) return varchar2; /*function*/ blockquoteClose constant varchar2(13) := ''; /* 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) := ''; function olistOpen(cclear in varchar2 DEFAULT NULL, cwrap in varchar2 DEFAULT NULL, cattributes in varchar2 DEFAULT NULL) return varchar2; /*function */ olistClose constant varchar2(5) := ''; 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) := ''; /*function */ menulistOpen constant varchar2(6) := '

'; /*function */ menulistClose constant varchar2(7) := ''; /*function */ dirlistOpen constant varchar2(5) := ''; /*function */ dirlistClose constant varchar2(6) := ''; /* END LIST tags */ /* SEMANTIC FORMAT ELEMENTS */ 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; /* END SEMANTIC FORMAT ELEMENTS */ /* PHYSICAL FORMAT ELEMENTS */ 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; /* END PHYSICAL FORMAT ELEMENTS */ /* HTML FORMS */ function formOpen(curl in varchar2, cmethod in varchar2 DEFAULT 'POST') return varchar2; /* No "standard" attributes in HTML 3.0 spec as of 6/11/95 */ 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) := ''; function formTextarea(cname in varchar2, nrows in integer, ncolumns in integer, calign 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 */ formTextareaClose constant varchar2(11) := ''; /*function */ formClose constant varchar2(7) := ''; /* 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) := ''; /*function */ tableClose constant varchar2(8) := ''; /* END HTML TABLES */ /* 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_REFERENCE(bodyOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(title, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(htitle, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(base, WNDS, WNPS, RNDS); PRAGMA RESTRICT_REFERENCE(isindex, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(linkRel, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(linkRev, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(meta, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(nextid, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(hr, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(line, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(br, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(nl, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(header, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(anchor, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(mailto, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(img, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(paragraph, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(address, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(comment, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(preOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(blockquoteOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(listHeader, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(listItem, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(ulistOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(olistOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(dlistOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(dlistTerm, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(dlistDef, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(cite, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(code, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(em, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(emphasis, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(keyboard, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(kbd, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(sample, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(strong, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(variable, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(bold, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(italic, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(teletype, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formCheckbox, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formHidden, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formImage, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formPassword, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formRadio, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formReset, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formSubmit, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formText, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formSelectOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formSelectOption, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formTextarea, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(formTextareaOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(tableOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(tableCaption, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(tableRowOpen, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(tableHeader, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(tableData, WNDS, WNPS, RNDS, RNPS); PRAGMA RESTRICT_REFERENCE(escape_sc, WNDS, WNPS, RNDS, RNPS); end; / show errors REM Creating HTPP package... create or replace package htpp as /* STRUCTURE tags */ procedure htmlOpen; procedure htmlClose; procedure headOpen; procedure headClose; --------------------------------------------------------------- /* Begin of Jiangang Guo's Procedures */ procedure javascriptOpen; procedure javascriptClose; /* End of Jiangang Guo's Procedures */ --------------------------------------------------------------- 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 ; 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 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 para; procedure paragraph(calign in varchar2 DEFAULT NULL, cnowrap in varchar2 DEFAULT NULL, cclear 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 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 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) ; /* END SEMANTIC FORMAT ELEMENTS */ /* PHYSICAL FORMAT ELEMENTS */ 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) ; /* END PHYSICAL FORMAT ELEMENTS */ /* HTML FORMS */ procedure formOpen(curl in varchar2, cmethod in varchar2 DEFAULT 'POST'); 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 formTextareaOpen(cname in varchar2, nrows in integer, ncolumns in integer, calign 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 */ /* 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 htpp.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; type htbuf_arr is table of varchar2(255) 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 htpp.print */ end; / show errors