PL/SQL Exceptions  «Prev  Next»

Raise Explicit Exceptions

Identifying Different types of errors

Objective: Match the different error types with their respective descriptions.

Instructions

In the left column below are three error types; their corresponding descriptions are in the right column.
Match the term i willeft column with haveinition in the right column.
When you think you have all the error types and their descriptions matched correctly, click the Submit button, and you will see whether you have matched the terms correctly.

Exercise scoring

You will receive three points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Submitting the exercise

For this exercise, match the term on the left with the definition on the right and then enter your solution into the exercise box.
  1. Predefined server error
  2. Non-predefined server error
  3. User-defined error
  1. You need to declare this error. However, Oracle will implicitly raise it.
  2. You need to declare this error.You will also need to raise it explicitly.
  3. You need not declare this error.Oracle will implicitly raise it.