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(' ' || cprompt ||''); htp.formText(cname, csize, cmaxlength, cvalue); end; procedure formStandardButtons2(csubmit varchar2, creset varchar2) is begin htp.formReset(creset); htp.formSubmit(NULL,csubmit); end; procedure formButtonRowOpen is begin htp.p(''); end; procedure formButtonRowItem(ctype varchar2, cname varchar2, 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('
'); end; procedure formStandardButtons4 is begin formButtonRowOpen; formButtonRowItem('RESET',NULL,'Alkuarvot'); formButtonRowItem('SUBMIT','optype','Päivitä'); formButtonRowItem('SUBMIT','optype','Uusi tietue'); formButtonRowItem('SUBMIT','optype','Poista'); formButtonRowClose; end; procedure formFieldText(cprompt varchar2, cname varchar2, cvalue varchar2, nrows int := 3, ncols int := 40) is begin htp.p(' ' || cprompt ||''); htp.formTextareaOpen(cname,nrows,ncols); htp.p(cvalue); htp.formTextareaClose; end; procedure header(ctitle varchar2, cinst_url varchar2, cbgr varchar2) is begin htp.p(''); htp.title(ctitle); htp.bodyOpen(cbgr, 'bgcolor=white'); htp.p(''); htp.p(''); htp.p(''); htp.p('
'); htp.p('Helsingin yliopisto, Tietojenkäsittelytieteen laitos
'); htp.p('Informaatiojärjestelmien harjoitustyö'); htp.p('
'); htp.p(''); htp.p(''); htp.p(''); htp.p('
'); htp.p('
'); htp.p('
'); htp.header(2,ctitle); end; procedure shortMessage(cmsg varchar2) is begin htp.p('

 

'); htp.p(cmsg); htp.p('

 

'); end; end; / show errors exit