Simple play icon Course

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.

About the author

Elias began his career as a postgraduate student participating in the Microsoft ImagineCup contest. He has been working with the .NET platform since 2003. Elias has been professionally architecting and implementing software for nearly 7 years, primarily based on the .NET platform. He is passionate about building rich and powerful applications using modern technologies. Elias is a certified specialist in Windows Applications and Service Communication Applications by Microsoft and he is a former c... more

Ready to upskill? Get started