求助存储过程修改。

[floger]

把SQL的存储过程修改成oracle的存储过程

CREATE PROCEDURE PAGINATION_JHGL
@SQL text, @Curpage int = 1, @PageSize int
AS
SET nocount ON
DECLARE @h int
SET @CurPage = (@CurPage-1)*@PageSize + 1
EXEC sp_cursoropen @h output, @sql, 1
EXEC sp_cursorfetch @h, 16, @CurPage, @PageSize
EXEC sp_cursorclose @h
SET nocount OFF
GO

[billpu]

...应该去oracle板块问问

[唐诗三百首]

如下供参考,只修改语法,程序逻辑还请楼主再确认.

SQL> create or replace procedure PAGINATION_JHGL(sSQL varchar2,Curpage number,PageSize number)
  2  as
  3   h number;
  4  Begin
  5    Curpage:=(Curpage-1)*PageSize+1;
  6    exec sp_cursoropen(h,sSQL,1);
  7    exec sp_cursorfetch(h,16,Curpage,PageSize);
  8    exec sp_cursorclose(h);
  9  end;
 10  /

[dawugui]

建议去oracle版问.