PL/SQL Error Handling Interview Question and Answers
9. |
What is the advantage of having a separate exception section within a PL/SQL code? |
|
The advantages of having a separate exception section within a PL/SQL code are as follows:-
It is easier to understand the program logic as it is easily visible and readable.
- Any error in any statement will be detected and handled easily.
|
10. |
What is the difference between user defined exceptions and Oracle defined exceptions? |
|
- User-defined exceptions are explicitly raised; whereas, oracle-defined exceptions are raised implicitly.
|
11. |
Describe the OTHERS exception handler? |
|
- The exception section handles only those errors that are specified; however, other errors that are not specified cannot be handled.
- To handle these errors explicitly, the OTHERS exception handler is used that is always defined as the last exception handler.
|
12. |
What is the difference between RAISE and RAISE_APPLICATION_ERROR? |
|
- RAISE is used to call pre-defined exceptions declared in the declarative section of the PL/SQL block.
- RAISE_APPLICATION_ERROR is used to call user-defined ORA – error messages from stored subprograms.
|