plsql 游标

create or replace procedure emp_pro2 (var_ename in  varchar2 ,var_eage in number,var_shuc out varchar2 ) is 

type emp_info is record (

var_name varchar2(50),

var_age  number

);

empinfo emp_info;

cursor cur_emp (var_cename in varchar2:='你好' ) is 

select e.name,e.age  from t_emp e where 1=1 or e.name=var_cename;

begin

 open cur_emp(var_ename);

 fetch cur_emp into empinfo;

 while cur_emp%found loop

 dbms_output.put_line('游标循环的名字为：'||empinfo.var_name||'     游标循环的年龄为:  '||empinfo.var_age); 

  fetch cur_emp into empinfo;

  end loop;

  

  close cur_emp;

    exception

     when NO_DATA_FOUND then

      dbms_output.put_line('错误没有找到数据'); 

end;

转载于:https://my.oschina.net/zhangtiant/blog/537134