SELECT CITYCODE into d_qsd FROM XCSDM where citytel=p_qsd;如果查不出记录赋给d_qsd 程序就会报错，怎么进行错误处理？

Question

begin
  yoursql
exception when no_data_found then
  ....
end

Answer 1

在过程中嵌套 BEGIN .... EXCEPTION...END 把错误忽略掉
begin
  ......
  ......
     begin
         SELECT CITYCODE into d_qsd FROM XCSDM where citytel=p_qsd;
     exception
         when others then
             null;
     end;
  .......
  .......
end;