Multiple choice technology databases

When you declare your own exception, you must ____ it explicitly

  1. DECLARE

  2. RAISE

  3. PRAGMA

  4. INITIATE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In PL/SQL, user-defined exceptions must be explicitly raised using the RAISE statement when the error condition occurs. Unlike predefined exceptions that are raised automatically by Oracle, your custom exceptions need manual triggering with RAISE exception_name;. This allows controlled error handling for application-specific conditions.

Keep practicing — related questions