Multiple choice technology databases

RAISE_APPLICATION_ERROR is a built-in procedure in oracle which is used to display the user-defined error messages along with the error number. What is the range of the error number for user defined error messages:

  1. Between -20000 and -20999

  2. Between -200000 and -209999

  3. Between -20001 and -20999

  4. Between -200001 and -209999
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

RAISE_APPLICATION_ERROR in Oracle allows user-defined error numbers from -20000 to -20999, giving developers 1000 error codes for custom exceptions. This range is reserved specifically for application-defined errors. Error numbers outside this range are reserved for Oracle system errors.

Keep practicing — related questions