在点击的按钮中写好触发的存储过程,在被触发的存储过程中写你需要的页面。 例如: function doinsert(){ document.all("inuserinfo").value=document.all("userinfo").value; document.inputform.action="SHOU_VIEW.divshow";-----注意:这里是该按钮点击后触发 的存储过程 document.inputform.target="fraList"; document.inputform.submit(); } 这个存储过程如下: procedure divshow(inuserinfo in varchar2) is
cursor cur_emp is select * FROM fruit_b WHERE fruit_b.del_flg = '0' AND ((inuserinfo IS NULL) OR((inuserinfo IS not NULL) AND fruit_b.kind=inuserinfo )) ; rec_emp fruit_b%rowtype;
例如:
function doinsert(){
document.all("inuserinfo").value=document.all("userinfo").value;
document.inputform.action="SHOU_VIEW.divshow";-----注意:这里是该按钮点击后触发
的存储过程
document.inputform.target="fraList";
document.inputform.submit();
}
这个存储过程如下:
procedure divshow(inuserinfo in varchar2) is
cursor cur_emp is
select *
FROM fruit_b
WHERE fruit_b.del_flg = '0'
AND ((inuserinfo IS NULL) OR((inuserinfo IS not NULL) AND fruit_b.kind=inuserinfo )) ;
rec_emp fruit_b%rowtype;
begin
htp.p('
<html>
<head>
<script language="javascript">
</script>
</head>
<body onload="init()">
<form name="showform">
<table id="fruittable" border=1 cellspacing=0>
<tr>
<th>no</th>
<th>name</th>
<th>kind</th>
</tr>
');
open cur_emp;
loop
fetch cur_emp
into rec_emp;
exit when cur_emp%notfound;
htp.p('
<tr>
<td>'|| rec_emp.no ||'</td>
<td>'|| rec_emp.name ||'</td>
<td>'|| rec_emp.kind ||'</td>
</tr>');
end loop;
htp.p('<input id="excelbtn" name="excelbtn" type="button" onclick="makeexcel();" value="goexcel">
</table>
</form>
</body>
</html>');
end divshow;