CREATE OR REPLACE PROCEDURE PAGEDDATA
(
STARTINDEX IN NUMBER,
ENDINDEX IN NUMBER
)
IS
BEGIN
SELECT * FROM (SELECT ROWNUM R ,T1.* FROM TABLEB T1 WHERE ROWNUM<STARTINDEX+ENDINDEX) T2 WHERE T2.R>=STARTINDEX;
END PAGEDDATA;
/总是提示编译有错,就是一个实现分页的存储过程,怎么回事?
(
STARTINDEX IN NUMBER,
ENDINDEX IN NUMBER
)
IS
BEGIN
SELECT * FROM (SELECT ROWNUM R ,T1.* FROM TABLEB T1 WHERE ROWNUM<STARTINDEX+ENDINDEX) T2 WHERE T2.R>=STARTINDEX;
END PAGEDDATA;
/总是提示编译有错,就是一个实现分页的存储过程,怎么回事?
(
STARTINDEX IN NUMBER,
ENDINDEX IN NUMBER,
cur out sys_refcursor
)
IS
BEGIN
open cur for
SELECT * FROM (SELECT ROWNUM R ,T1.* FROM TABLEB T1 WHERE ROWNUM<STARTINDEX+ENDINDEX) T2 WHERE T2.R>=STARTINDEX;
END PAGEDDATA;不能在过程中单纯地运行查询语句
可以用游标将结果集输出
可以把用SELECT检索的回的记录保存到一个记录类型变量中
再使用DBMS_OUTPUT.PUT_LINE()函数进行输出