我正在尝试编写一个简单的游标,然后打开、取值和关闭。下面是我的游标代码。
DECLARE
id cur.sid%TYPE;
s_num cur.serial#%TYPE;
CURSOR cur IS
SELECT sid, serial#
FROM v$session WHERE username = 'ABC';
BEGIN
OPEN cur;
LOOP
FETCH c cur INTO id, s_num;
dbms_output.put_line(id || ' ' || s_num);
END LOOP;
CLOSE cur;
END;
/运行此命令时,我看到以下错误消息:
FETCH c cur INTO id, s_num;
*
ERROR at line 9:
ORA-06550: line 9, column 9:
PLS-00103: Encountered the symbol "CUR" when expecting one of the following:
. into bulk
The symbol "." was substituted for "CUR" to continue.任何一种解决这个问题的方向都是值得感谢的。谢谢。
发布于 2014-01-18 15:48:43
使用IMPLICIT open和fetch游标的简化版本(参数化)
DECLARE
CURSOR cur(v_USER VARCHAR2)
IS
SELECT sid, serial# FROM v$session where username = v_USER;
BEGIN
FOR I IN cur('ABC')
LOOP
dbms_output.put_line(I.sid || ' ' || I.serial#);
END LOOP;
END;发布于 2014-01-18 15:40:39
FETCH c cur INTO id, s_num; c中的
id v$session.sid%type;
s_num v$session.serial#%type;
exit when cur%notfound;作为循环的退出条件。声明游标cur是SELECT sid,serial# FROM v$session where username = 'ABC';id v$session.sid%type;s_num v$session.serial#%type;BEGIN OPEN cur;LOOP FETCH cur INTO id,s_num;exit when cur%notfound;dbms_output.put_line(id |‘’|| s_num);END LOOP;CLOSE cur;END;
https://stackoverflow.com/questions/21198682
复制相似问题