17,086
社区成员
发帖
与我相关
我的任务
分享oracle+proc滚动游标无效
EXEC SQL WHENEVER SQLERROR do sql_error("Oracle error");
EXEC SQL DECLARE temp_curcor SCROLL CURSOR FOR
SELECT ename
FROM EMP;
EXEC SQL OPEN temp_curcor;
/*FETCH最后一行记录*/
EXEC SQL FETCH LAST temp_curcor INTO :emp_name;
..................
编译的时候报错如下：
Syntax error at line 263, column 31, file test.pc:
Error at line 263, column 31 in file test.pc
EXEC SQL DECLARE salespeople SCROLL CURSOR FOR
..............................1
PCC-S-02201, Encountered the symbol "SCROLL" when expecting one of the following
:
. @ cursor, database, statement, table, type, partition,
The symbol "table," was substituted for "SCROLL" to continue.
......
期待指点，谢谢！
EXEC SQL DECLARE temp_curcor SCROLL CURSOR FOR
SELECT ename
FROM EMP;
EXEC SQL OPEN temp_curcor;
/*FETCH最后一行记录*/
EXEC SQL FETCH LAST temp_curcor INTO :emp_name;
..................
编译的时候报错如下：
Syntax error at line 263, column 31, file test.pc:
Error at line 263, column 31 in file test.pc
EXEC SQL DECLARE salespeople SCROLL CURSOR FOR
..............................1
PCC-S-02201, Encountered the symbol "SCROLL" when expecting one of the following
:
. @ cursor, database, statement, table, type, partition,
The symbol "table," was substituted for "SCROLL" to continue.
......
期待指点，谢谢！
...全文
请发表友善的回复…
发表回复
shmylm4201 2012-11-16
- 打赏
- 举报
谢谢你的回复，用你的方式或许可以实现（没有实际验证），但是我只是想知道为什么用滚动游标实现不行？
软件钢琴师 2012-11-15
- 打赏
- 举报
for i in 1...4 loop
end loop;
