Handling exceptions - Oracle PL SQL Course - Lesson 22 | SQL courses

Duration: 16:44 min

Summary: During the execution of lines inside a PL/SQL can error can occurs because of many reasons. In order to deal with this error Oracle provide a mechanism called exception that allow the developer to trap and handle and provide user-friendly messages to the user. This video discusses how to proper handle the messages generated by Oracle when an error happens inside PL/SQL block by using the EXCEPTION clause. Some examples show how to capture a specific message error and how to handle the technical message provided when such an errors occurs. Finally, the video demonstrate how to create a user-generated message to provide a more adequate description of what happened to the user instead of providing a raw technical explanation that cannot be understandable by the end user.