ORACLE    的存储过程里面   select   aaa   into   var1   from   tablea   如果记录为空,会出错.怎么解决?
网上有很多解决方案,但我觉得比较可行的还是:
begin
-----
exception   when   no_data_found   then  
-----
end;

 -------------------------------------------------------------------------

select XXX into 如果有参数时用 EXECUTE IMMEDIATE

 -------------------------------------------------------------------------

   EXECUTE IMMEDIATE 'select count(1) from (' || TMPSQL || ')'
        INTO IRECORDCOUNT;