procedure query(page number,sub_id number,cur out mycur) is
v_begin number;
v_end number;
begin
v_begin:=rows_per_page*(page-1);
v_end:=rows_per_page*page;
open cur for
select b.problem_title,b.problem_option from
(select a.*,rownum as row1 from
(select * from table_problemdepot where subject_id=sub_id) a where rownum<=v_end)b
where row1> v_begin ;
end;
end controlPage;
注意:必须放在包中