declare
v_pn number := 2462;
cursor c_cursor_relcon is
select sn, relatives_id, pn, customer_name from info_relatives_concern where pn = v_pn;
begin
if not c_cursor_relcon%isopen then
open c_cursor_relcon;
end if;
for c_rec in c_cursor_relcon loop
dbms_output.put_line(c_rec.sn || ',' || c_rec.relatives_id || ', ' || c_rec.pn || ', ' || c_rec.customer_name);
end loop;
close c_cursor_relcon;
end;这是我的代码,执行时总是提示 PL/SQL:游标已打开,但我运行close c_cursor_relcon又说无效的sql语句
v_pn number := 2462;
cursor c_cursor_relcon is
select sn, relatives_id, pn, customer_name from info_relatives_concern where pn = v_pn;
begin
if not c_cursor_relcon%isopen then
open c_cursor_relcon;
end if;
for c_rec in c_cursor_relcon loop
dbms_output.put_line(c_rec.sn || ',' || c_rec.relatives_id || ', ' || c_rec.pn || ', ' || c_rec.customer_name);
end loop;
close c_cursor_relcon;
end;这是我的代码,执行时总是提示 PL/SQL:游标已打开,但我运行close c_cursor_relcon又说无效的sql语句
http://topic.csdn.net/u/20120523/10/28c92b6e-e59d-4a7c-a9d5-9a59bfb76d65.html