Skip to Content
0
Oct 16, 2013 at 10:15 AM

Best way to deal with “no data found” exceptions

1266 Views

Hi,

Does anyone have a best-practice to deal with “no data found” exceptions:

For example:

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.

Thanks,

D.