oracle分页

oracle分页存储过程

create or replace procedure p_fenye(pageindex in number, pagesize in number) is
  user_ids   NVARCHAR2(40);
  user_names NVARCHAR2(100);
  passwords  NVARCHAR2(40);
begin
  select user_id , user_name , password
  into user_ids,user_names,passwords
  from
    (select rownum row, a.*
            from (select * from sys_user order by user_id) a
           where rownum < pageindex * pagesize) ta
   where row < (pageindex - 1) * pagesize;
end p_fenye;

这个为什么抱错啊？在网上找了半天都说这么写是可以的。....在线等回复.......