posted 4 years ago
Those are rather general questions. However I believe that somewhere in the Oracle tutorial about exceptions: Lesson: Exceptions you will find the information you're looking for. There's a lot to read there but it covers the topic quite thoroughly. I highly recommend you spend some time going through it.