plsql - What is bad in "When Others Then Null" in PL/SQL?

Question

I just read this question, and a solution states that:

The fact that you don't know you got the NO_DATA_FOUND exception suggests that you have made one of the biggest errors PL/SQL developers ever make:

EXCEPTION
    -- Never do this in real code!!!
   WHEN OTHERS THEN NULL;
END;

Could you explain me what is the error in this statement and what would you do to avoid doing that...

Answer 1

The problem is, that you are catching all exceptions, and then ignoring them. You'll never know when something went wrong.