Oracle PL/SQL Einzel-Tipp ansehen

Sub Block Exceptions

Tipp 8

BEGIN
<<Block_1>> ------------------------------- Block 1 ---------
DECLARE
        
BEGIN    
    DBMS_OUTPUT.ENABLE(10000);                
    <<Block_2>> ---------------------------- Block 2 ---------
    DECLARE
        
    v_sal    emp.sal%TYPE;
    BEGIN            
        SELECT sal INTO v_sal FROM emp WHERE empno=10000;
            
    EXCEPTION
        WHEN ZERO_DIVIDE THEN
            DBMS_OUTPUT.PUT_LINE('Fehler in Block_2');
            DBMS_OUTPUT.PUT_LINE('Fehlertext :'||sqlerrm);
    END Block_2;
            
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('Fehler in Block_1');
        DBMS_OUTPUT.PUT_LINE('Fehlertext :'||sqlerrm);
END Block_1;
END;
/

Ergebnis: Fehler in Block_1 Fehlertext :ORA-01403: Keine Daten gefunden