This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Oct 11, 2012 7:48 AM by Marwim Go to original post RSS
  • 15. Re: Procedure Exception
    Marwim Expert
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    oh yes, i used OP's code.. it was not tested..
    sorry for confusion.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points