You are masking the error yourself with "WHEN OTHERS" in the exception clause. if you want to reveal the true error to the front end, then don't hide it with your own code.