5) From the following which of the statement is true
- Published on 16 Jun 15
a. Any procedure cannot raise an error and return a system message and error number
b. Error numbers ranging from 20000 to 20999 are system defined error messages
c. Oracle checks uniqueness of user defined messages
d. The Raise_Application_Error is used for raising user defined error messages.
ANSWER: The Raise_Application_Error is used for raising user defined error messages.
The Raise_Application_Error is used when the user wants to raise an error in the application. It is usually used when a user wants user defined error message.