PL/SQL 예외처리(EXCEPTION)

PL/SQL  예외처리(EXCEPTION)

 

 실습으로 배워보자 !

DECLARE

    no_emp EXCEPTION;
    
    v_ename emp.ename%TYPE;
    
BEGIN

    BEGIN
    
        SELECT ename INTO v_ename
        
        FROM emp
        
        WHERE empno = 8000;
        
    EXCEPTION
    
        WHEN NO_DATA_FOUND
        
        RAISE no_emp;
        
    END;
    
EXCEPTION

    WHEN no_emp THEN
    
        DBMS_OUTPUT.PUT_LINE('no_emp');
        
END;
/