VARIABLE g_message VARCHAR2(250)

DEFINE p_sal = 12000

DECLARE
   v_name employees.last_name%TYPE;
   v_sal employees.salary%TYPE := &p_sal;

   table_does_not_exist exception;
   PRAGMA EXCEPTION_INIT(table_does_not_exist, -942);

BEGIN

   SELECT last_name INTO v_name FROM employe WHERE salary = v_sal;

   DBMS_OUTPUT.put_line(v_name);


 EXCEPTION

   WHEN table_does_not_exist then
   :g_message := 'table dose not exist';


   WHEN NO_DATA_FOUND THEN
   :g_message := 'No employee with a salary of '||TO_CHAR(v_sal);

   WHEN OTHERS THEN
   :g_message := 'Some other error occurred.';
 END;
 /
 PRINT g_message