Thats what I thought - but if I put the IF statement inside the cursor I get no output at all??:

for rec in c2 loop
delete from stats$database_instance where snap_id=rec.snap_id;
if SQL%NOTFOUND then
dbms_output.put_line('No hanging SQL to delete');
else
dbms_output.put_line('Hanging data deleted');
end if;
end loop;
commit;