create or replace PROCEDURE xj_homepage (cols IN owa_util.ident_arr) IS
col_counter INTEGER; counter INTEGER; ID CHAR(2); CURSOR C1 IS
select PRIVELEGE_TABLE from previlege_range where PRIVELEGE_ID = ID;
cPRIVELEGE_TABLE C1%ROWTYPE;BEGIN htp.htmlopen; htp.headopen;
htp.title('主頁'); htp.headclose; htp.bodyopen; htp.line;
htp.img('/ows-img/ows.gif'); htp.header(1, '主頁'); htp.line;
htp.paragraph;
select count(*) into counter from user_define where USER_ID = cols(2) and USER_PASS = cols(3);
if (counter > 0) then
select PRIVELEGE_ID into ID from user_define where USER_ID = cols(2) and USER_PASS = cols(3);
htp.print(' 您的權(quán)限：'|| ID);
htp.formOpen(owa_util.get_owa_service_path|| 'xj_resurlts') ;
htp.formhidden('COLS','dummy');
htp.formSelectOpen('COLS','選擇查詢表：') ; open C1; loop
fetch C1 into cPRIVELEGE_TABLE; EXIT WHEN C1%NOTFOUND;
htp.formSelectOption(cPRIVELEGE_TABLE.PRIVELEGE_TABLE); end loop;
close C1; htp.formSelectClose; htp.paragraph;
htp.formsubmit(NULL,'確認(rèn)'); htp.formClose; else
htp.print(' 您輸入的標(biāo)識符：'|| cols(2)); htp.paragraph;
htp.print(' 您輸入的口令：'|| cols(3)); htp.paragraph;
htp.print('用戶標(biāo)識符或口令錯!請返回登錄窗口。') ; htp.paragraph; end if;
htp.anchor('http://www.sql.com.cn','sql 技術(shù)站點'); htp.line;
htp.address('(c)1998 豆腐制作'); htp.bodyclose; htp.htmlclose;
END; 來自: ASP專區(qū)