ORA-01403: no data found

ORA-01403: no data found will commonly occur in below scenarios:

• Implicit cursors without proper error handling: example below:

DECLARE

   v_empno   NUMBER (9);

BEGIN

   SELECT empno

     INTO v_empno

     FROM emp

    WHERE ename LIKE 'Z%';

END;

Error at line 2

ORA-01403: no data found

ORA-06512: at line 4