fetch returns undef if either there are no more rows or when en error occurs.

You can distinguish these cases by checking $sth-err.

So in code you can do something like this:

while( defined $sth->fetch) {
 # do something with fetched data
}
if($sth->err) {
# handle error
}
else {
# no more data
}
[download]