I am doing a select count(*) into v_cnt where ****;
in my PL/SQL program and I am getting a no data found error. I thought that if you are doing a count it would be zero or greater than zero. How would I get a no data found error?
Are you sure you got the error because of this statement?
COUNT function never returns null, that's true. Maybe you better debug you pl/sql program.
Could you provide us with the whole text of your block?