Oracle存储过程使用游标

declare 
  arg VARCHAR2(30);--定义一个变量
  cursor cur is--定义游标
  select t.* from table_t t;
  cur_Object cur%rowtype;
   
  begin
  open cur;--打开游标
  loop 
    fetch cur into cur_Object;--可以理解为遍历游标cur的每一行结果集赋值给cur_Object对象
  exit when cur%notfound;
    arg := cur_Object.name;--给变量赋值
    begin
      select * from table_b b where b.name = arg;
    exception when others then--异常处理
        dbms_output.put_line('name:'||arg);
    end; 
   end loop;
  close cur;
  end;
/