Re: PL/SQL with select into returning no rows

If I correctly understood your problem, I'd suggest to try catching the NO_DATA_FOUND exception, as in:

...

-- Some stuff

BEGIN

	SELECT	ename
	INTO		my_ename
	FROM		emp
	WHERE	empno = my_empno;
EXCEPTION
	WHEN NO_DATA_FOUND THEN
		my_ename := NULL; -- Unkown name, ok to continue

• Continue normal processing
  ...