AI编程社区

Set serveroutput on;   
declare
    type my_ref_cur is ref cursor;
    tmp_cur my_ref_cur;
    sqlStr varchar2(500);
    v_row xuesheng%rowtype;
begin
    sqlStr:='select xs.xing_ming,xs.yu_wen from xuesheng xs';
    open tmp_cur for sqlStr;
    
    loop
         fetch tmp_cur into v_row.xing_ming,v_row.yu_wen;
         exit when tmp_cur%NOTFOUND;
         
         dbms_output.put_line('xingming:'||v_row.xing_ming);
    end loop;
    close tmp_cur;
end;
/