Hi,

a collega used frequently a begin, select ... and exception when
no_data_found. I am used to use a cursor with %notfound to check is a
record is found.

The question is, does anyone knows what is better to do??

<ron.van.der.zwaag@abp.nl> a écrit dans le message de news: 1135765418.178154.302390@g43g2000cwa.googlegroups. com...
| Hi,
|
| a collega used frequently a begin, select ... and exception when
| no_data_found. I am used to use a cursor with %notfound to check is a
| record is found.
|
| The question is, does anyone knows what is better to do??
|

Imho, the one that is easier to read and maintain in your code.

Regards
Michel Cadot