Does anyone have a best-practice to deal with “no data found” exceptions:
declare vValue integer;
select x into vValue from table A where ……; /* no data returned with the "where clause */
/* “no data found” Exception breaks code execution*/
using "select count(x) from table A where ……" is possible but not the ideal solution.