RaiseApplicationError is used for raising user defined error messages

Q.  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.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)