Interested to Buy Any Domain ? << Click Here >> for more details...
In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 12576 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subba
When Others exception needed to be handled last. If we use
When Others first, and then other exceptions, following
error will be prompted:
ORA-06550: line 8, column 3:
PLS-00370: OTHERS handler must be last among the exception
handlers of a block
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
| Is This Answer Correct ? | 38 Yes | 1 No |
Answer / uma
If we use when others first all the exceptions will be
caught by this block even when specific exception blocks
are present after that.Also no compiler error will be thrown
| Is This Answer Correct ? | 9 Yes | 16 No |
What is meant by redo log buffer ?
What is a nvl function? How can it be used?
How will you write a query to get a 5th rank student from a table student_report?
What is an Index Segment ?
What is a trigger and what are its types in oracle?
What are the numeric comparison operations?
is there a tool to trace queries, like profiler for sql server?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to loop through data rows in the implicit cursor?
How do I find my oracle client driver version?
find the second highest salary of the emp table
Oracle General 
