--value_error example

DECLARE
A NUMBER;
B NUMBER;
C NUMBER;
BEGIN
SELECT ENAME,SAL,DEPTNO INTO A,B,C FROM EMP WHERE EMPNO=&EMPNO;
DBMS_OUTPUT.PUT_LINE(A||' '||B||' '||C);
EXCEPTION
WHEN VALUE_ERROR THEN
DBMS_OUTPUT.PUT_LINE('SORRY DATA TYPES ARE MISMATCHING');
END;