Expanded Library

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Handling Exceptions

by Elias Fofanov

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.

Ready to upskill? Get started