oracle 异常处理

create or replace procedure tranLan_i18n as
ename varchar2(128) := '';
begin

for obj in (select c_referenceid,c_name from SYS_I18N_TEMP where c_language = 'zh_CN')
  loop
 begin
 select t2.c_name into  ename from SYS_I18N_TEMP t2
 where t2.c_referenceid = obj.c_referenceid and c_language = 'en_US';
 EXCEPTION WHEN NO_DATA_FOUND THEN
    dbms_output.put_line(obj.c_referenceid);
end;
  update SYS_I18N s set s.c_name = ename where s.c_language = 'en_US' and s.c_referenceid in (
  select s2.c_referenceid from SYS_I18N_TEMP s2
  where s2.c_language = 'zh_CN' and s2.c_name = obj.c_name
  );

 commit;
end loop;
end tranLan_i18n;