REM this package is based on the fuctions and procedures of Juhani Kuittinen REM which are revised and collected into a package by Harri Laine create or replace package iht as procedure back(n int := -1); procedure footer( cdate varchar2, csignature varchar2); procedure formEnd; procedure formFieldsOpen(curl varchar2, cmethod varchar2); procedure formfieldsClose; procedure formField(cprompt varchar2, cname varchar2, csize integer, cmaxlength integer, cvalue varchar2); procedure formStandardButtons2(csubmit varchar2, creset varchar2); procedure formButtonRowClose; procedure formButtonRowOpen; procedure formButtonRowItem(ctype varchar2, cname varchar2, cvalue varchar2); procedure formFieldText(cprompt varchar2, cname varchar2, cvalue varchar2, nrows int := 3, ncols int := 40); procedure formStandardButtons4; procedure header(ctitle varchar2, cinst_url varchar2, cbgr varchar2); procedure shortMessage(cmsg varchar2); end; / show errors create or replace package body iht as procedure back(n int := -1) is begin htp.para; htp.p('Siirry: ' || 'takaisinpäin'); htp.p(' eteenpäin.'); end; procedure footer( cdate varchar2, csignature varchar2) is begin htp.hr; htp.small(cdate || ' ' || csignature || ' http://kontti.helsinki.fi:8889'); htp.bodyClose; htp.htmlClose; end; procedure formEnd is begin htp.formClose; end; procedure formFieldsOpen(curl varchar2, cmethod varchar2) is begin htp.formOpen(curl,cmethod,NULL); htp.tableOpen('border=0'); end; procedure formfieldsClose is begin htp.tableClose; end; procedure formField(cprompt varchar2, cname varchar2, csize integer, cmaxlength integer, cvalue varchar2) is begin htp.p('
'); if ctype='SUBMIT' or ctype='submit' then htp.formSubmit(cname,cvalue); else htp.formReset(cvalue); end if; end; procedure formButtonRowClose is begin htp.p(' |
'); htp.p(cmsg); htp.p('
'); end; end; / show errors exit