Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Handling Exceptions
This course will teach you what exceptions are in Oracle DBMS, how to handle predefined and non-predefined exceptions, and how to raise them to protect business logic. Covers the exceptions section in the 1Z0-149 certification exam.
What you'll learn
Any program written in any programming language may face an exceptional situation when an error has occurred. Different programming languages provide different mechanics to tackle the errors. The most popular mechanic is based on the notion of exceptions rather than plain error codes. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Handling Exceptions, you'll learn the three types of exceptions: predefined, non-predefined, and user-defined. First, you’ll explore what situations can potentially lead to exceptions being thrown. Then, you’ll discover the difference between predefined and non-predefined exceptions. Finally, you’ll see in practice how to handle them and look at the common mistakes when dealing with exceptions made by beginner developers. By the end of this course, you will have the working knowledge to know why raising exceptions is the mechanism which helps you to protect the business logic.
Table of contents
- Setting up the Environment 5m
- What Is an Exception? 3m
- Demo: Exceptions 4m
- Exception Types 2m
- Catching Predefined Exceptions 5m
- Catching Multiple Types of Exceptions 8m
- Dealing with Exceptions: 4 Strategies 9m
- Non-predefined Exceptions 5m
- Propagating Exceptions 4m
- User-defined Exceptions 4m
- Demo: Raising and Handling User-defined Exceptions 4m