分页的存储过程

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;

注意：必须放在包中