[转]Oracle ORA-01403: no data found Exception SYS_REFCURSOR
本文转自：http://*.com/questions/9104153/what-is-the-correct-way-to-deal-with-this-oracle-ora-01403-no-data-found-exceptThis leads to the famil...
[PL/SQL] 如何规避异常ORA-01403
如果mytable表中不存在 ID = 123 的数据，那么SELECT Flag INTO flag FROM mytable WHERE ID = 123 将抛出异常ORA-01403SELECT nvl(max(Flag),'') INTO flag FROM mytable WHERE ID...