ORA error

ORA-01403

ORA-01403: no data found

Quick fix

Cause: In PL/SQL, a SELECT ... INTO returned no rows (or code read an associative array element that was never assigned). It is raised as the NO_DATA_FOUND exception.
Fix: Handle it where a missing row is a normal case: add an EXCEPTION WHEN NO_DATA_FOUND block, or select COUNT(*) / use a cursor loop instead of SELECT INTO.

BEGIN
  SELECT salary INTO v_salary FROM employees WHERE employee_id = p_id;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    v_salary := NULL;
END;

ORA-01403: no data found – SELECT INTO returned zero rows. Handle with WHEN NO_DATA_FOUND.

Database