1 2 Previous Next 16 Replies Latest reply: Oct 11, 2012 9:48 AM by Marwim Go to original post RSS
      • 15. Re: Procedure Exception
        Marwim
        exception when others
        return 'other exception';
        when no_data_found
        return 'no data';
        end;
        Wrong
        BEGIN
            NULL;
        EXCEPTION
            WHEN OTHERS THEN
                dbms_output.put_line(SQLERRM);
            WHEN NO_DATA_FOUND THEN
                dbms_output.put_line(SQLERRM);
        END;
        /
            WHEN OTHERS THEN
            *
        FEHLER in Zeile 9:
        ORA-06550: Zeile 9, Spalte 5:
        PLS-00370: OTHERS handler must be last among the exception handlers of a block
        ORA-06550: Zeile 0, Spalte 0:
        PL/SQL: Compilation unit analysis terminated
        Regards
        Marcus

        Edited by: Marwim on 11.10.2012 16:48
        • 16. Re: Procedure Exception
          812975
          oh yes, i used OP's code.. it was not tested..
          sorry for confusion.
          1 2 Previous Next