Multiple choice

____________ directs the complier to add the user defined error message to the oracle error number.

  1. Pragma Init Exception

  2. Pragma Exception

  3. ORA_EXCEPTION

  4. ORA_USER_EXCEPTION
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

PRAGMA EXCEPTION_INIT is a compiler directive that associates a user-defined error message with a specific Oracle error number. The other options are not valid PL/SQL constructs - ORA_EXCEPTION and ORA_USER_EXCEPTION don't exist, and 'Pragma Exception' is incomplete syntax.

Keep practicing — related questions