Exception Handling

Exception Handling in PL/SQL

Use EXCEPTION to catch and handle errors.

BEGIN
  SELECT salary INTO v_sal FROM employees WHERE employee_id = 999;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.PUT_LINE('Employee not found.');
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Some error occurred.');
END;