Oracel 创建分页存储过程

CREATE OR REPLACE PROCEDURE proc_getInfoPage(
	pageIndex int,
	pageSize int, 
	total OUT int,--输出总数量
	v_cursor OUT SYS_REFCURSOR --游标输出表信息 
)
AS 
BEGIN  		
	SELECT  COUNT(1) INTO total  from table1;

	OPEN v_cursor FOR
	  SELECT t.*  FROM (
		SELECT pb.*,ROW_NUMBER() over(ORDER BY pb.Id)  rownums FROM table1 pb  
	)t WHERE t.rownums BETWEEN (pageIndex-1)*pageSize+1  AND  pageIndex *pageSize;
 
END;